how to convert linq list to datatable

Reylin Mathew

7y3.6k.NET

this is my code

ataTable dt = new DataTable();

dt = ds.Tables[0];

var result = from r in dt.AsEnumerable()

group r by new { ID = r.Field("ID"), time1 = r.Field("DATE") } into IdGroup

let row = IdGroup.First()

select new

{

ID = IdGroup.Key,

DATE = row.Field("DATE"),

CODE = row.Field("CODE"),

NAME = row.Field("NAME"),

NUMBER = row.Field("NUMBER"),

NAME = row.Field("NAME"),

AMOUNT = row.Field("AMOUNT")

};

var dtdata=result.ToList();

how to convert datatable.

thnkx in adva

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
Accepted answer
Hi, Remove .ToList() from result.and use below code. var dt = result.CopyToDataTable();
Jignesh Kumar7y ago
Hi Reylin,

Please try this link which will help you,
https://www.c-sharpcorner.com/blogs/converting-generic-list-into-datatable
Veerendra Annigere7y ago
Hi
public static DataTable ConvertToDataTable(this IEnumerable dataList) where T:class
      {
          DataTable convertedTable = new DataTable();
          PropertyInfo[] propertyInfo = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
          foreach(PropertyInfo prop in propertyInfo)
          {
              convertedTable.Columns.Add(prop.Name);
          }

          foreach(T item in dataList)
          {
              var row = convertedTable.NewRow();
              var values = new object[propertyInfo.Length];
              for(int i=0;i
              {
                  var test = propertyInfo[i].GetValue(item, null);
                  row[i] = propertyInfo[i].GetValue(item,null);
              }
              convertedTable.Rows.Add(row);
          }
          return convertedTable;
      }
Usage:
DataTable listTable = YourList.ConvertToDataTable();
Sivakumar Koneti7y ago
Hello Reylin Mathew

Follow the below you can get exact solution

https://stackoverflow.com/questions/18608959/convert-linq-query-results-to-datatable-c-sharp
Madan Shekar7y ago
1. public static DataTable ToDataTable(List items)
2. {
3. DataTable dataTable = new DataTable(typeof(T).Name);
5. //Get all the properties
6. PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
7. foreach (PropertyInfo prop in Props)
8. {
9. //Defining type of data column gives proper data table
10. var type = (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>) ? Nullable.GetUnderlyingType(prop.PropertyType) : prop.PropertyType);
11. //Setting column names as Property names
12. dataTable.Columns.Add(prop.Name, type);
13. }
14. foreach (T item in items)
15. {
16. var values = new object[Props.Length];
17. for (int i = 0; i < Props.Length; i++)
18. {
19. //inserting property values to datatable rows
20. values[i] = Props[i].GetValue(item, null);
21. }
22. dataTable.Rows.Add(values);
23. }
24. //put a breakpoint here and check datatable
25. return dataTable;
26. }
use above method and pass apropriate parameters properly.