List to data table

C# Corner

List to data table

9 Replies

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

Ananth G9y ago
Accepted answer
1. public partial class Form1 : Form
2. {
3. public Form1()
4. {
5. InitializeComponent();
6. List<ad> obj = new List<ad>();
7. obj.Add(new ad { Name = "ss" });
8. DataTable dt = obj.ToDataTable();
9. }
10. }
12. internal class ad
13. {
14. public string Name { get; set; }
15. }
16. public static class ExtensionMethod
17. {
18. public static DataTable ToDataTable<T>(this List<T> iList)
19. {
20. DataTable dataTable = new DataTable();
21. PropertyDescriptorCollection propertyDescriptorCollection =
22. TypeDescriptor.GetProperties(typeof(T));
23. for (int i = 0; i < propertyDescriptorCollection.Count; i++)
24. {
25. PropertyDescriptor propertyDescriptor = propertyDescriptorCollection[i];
26. Type type = propertyDescriptor.PropertyType;
28. if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable<>))
29. type = Nullable.GetUnderlyingType(type);
32. dataTable.Columns.Add(propertyDescriptor.Name, type);
33. }
34. object[] values = new object[propertyDescriptorCollection.Count];
35. foreach (T iListItem in iList)
36. {
37. for (int i = 0; i < values.Length; i++)
38. {
39. values[i] = propertyDescriptorCollection[i].GetValue(iListItem);
40. }
41. dataTable.Rows.Add(values);
42. }
43. return dataTable;
44. }
45. }
Define this method to another class like above code..
above code is execution sample its working fine
0
Harshal Patil9y ago
public DataTable ToDataTable(List items)

{

DataTable dataTable = new DataTable(typeof(T).Name);

//Get all the properties

PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);

foreach (PropertyInfo prop in Props)

{

//Setting column names as Property names

dataTable.Columns.Add(prop.Name);

}

foreach (T item in items)

{

var values = new object[Props.Length];

for (int i = 0; i < Props.Length; i++)

{

//inserting property values to datatable rows

values[i] = Props[i].GetValue(item, null);

}

dataTable.Rows.Add(values);

}

//put a breakpoint here and check datatable

return dataTable;

}
0
Khaja Moizuddin9y ago
ust add this function and call it, it will convert List to DataTable. public static DataTable ToDataTable(List items) { DataTable dataTable = new DataTable(typeof(T).Name); //Get all the properties PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance); foreach (PropertyInfo prop in Props) { //Setting column names as Property names dataTable.Columns.Add(prop.Name); } foreach (T item in items) { var values = new object[Props.Length]; for (int i = 0; i < Props.Length; i++) { //inserting property values to datatable rows values[i] = Props[i].GetValue(item, null); } dataTable.Rows.Add(values); } //put a breakpoint here and check datatable return dataTable; }
0
Midhun Tp9y ago
Hi,

Please go through below article -

http://www.c-sharpcorner.com/UploadFile/1a81c5/list-to-datatable-converter-using-C-Sharp/
0
Dinesh Santhalingam9y ago
Ananth,
There is an error populating in my code .
Error 5 Extension method must be defined in a non-generic static class
0
Ananth G9y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;

add above reference
+1
Dinesh Santhalingam9y ago
Ananth,
PropertyDescriptorCollection shows an error-Missing assembly reference
0
Jasbeer Singh9y ago
You ca use this method to get Datatable from list.
You can pass list to this function

+1
Ananth G9y ago
1. DataTable dt = YourList.ToDataTable();
3. public static DataTable ToDataTable(this List iList)
4. {
5. DataTable dataTable = new DataTable();
6. PropertyDescriptorCollection propertyDescriptorCollection =
7. TypeDescriptor.GetProperties(typeof(T));
8. for (int i = 0; i < propertyDescriptorCollection.Count; i++)
9. {
10. PropertyDescriptor propertyDescriptor = propertyDescriptorCollection[i];
11. Type type = propertyDescriptor.PropertyType;
13. if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable<>))
14. type = Nullable.GetUnderlyingType(type);
17. dataTable.Columns.Add(propertyDescriptor.Name, type);
18. }
19. object[] values = new object[propertyDescriptorCollection.Count];
20. foreach (T iListItem in iList)
21. {
22. for (int i = 0; i < values.Length; i++)
23. {
24. values[i] = propertyDescriptorCollection[i].GetValue(iListItem);
25. }
26. dataTable.Rows.Add(values);
27. }
28. return dataTable;
29. }
Ur list
List licenselist = new List();
DataTable dt = licenselist.ToDataTable();
+1