Hi! In our ASP.NET project we use CopyToDatatable for generating dynamic excel-exports out of LINQ-queries (SQL). In our LINQ-queries we define which columns to pick. The problem is that the column-order of the datatable does not fit the select order. Example: Code Snippet Dim var = From t In dc.ViewExpenseTemplates _ Where t.ExpenseTemplateID.ToString = ExpTemplId _ Order By t.ExpenseType _ Select t.ExpenseType, _ t.MasterExpenseTypeID, _ t.LimitAmount, _ t.IsManagerInformation, _ t.IsBlockExceed,
Read More...