<% foreach (ColumnSchema column in Table.Columns) { switch(column.CSDataType){ case "DateTime": %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").ToString("yyyy-MM-dd"), <% break; case "DateTime?": %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").HasValue ? row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").Value.ToString("yyyy-MM-dd") : string.Empty, <% break; default: %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>"), <% break; } } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.Text %> <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> list.Add(new { id = "<%= column.AliasName %>", name = "<%= column.Text %>", value = columnSchema.TableName, group = "group1", editor = textbox }); <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.AliasName %> = '<%= column.Text %>', <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> dataSet.Tables[0].Columns["<%= column.AliasName %>"].Caption = "<%= column.Text %>"; <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> @<%= column.AliasName %> <%= column.DataType %><%= GetLengthText(column) %>, -- <%= column.Text %> <% } %> -------------------------------------------------------------------------------- <% StringBuilder sb = new StringBuilder(); foreach (ColumnSchema column in Table.SelectedColumns) { sb.Append(column.AliasName).Append(", "); } %> <%= sb.ToString() %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.AliasName %> nvarchar(50), -- <%= column.Text %> <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.AliasName %>, -- <%= column.Text %> <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.AliasName %> AS <%= column.Text %>, <% } %> -------------------------------------------------------------------------------- <% foreach (ColumnSchema column in Table.SelectedColumns) { %> <%= column.Text %>： <% } %>