List to data table

Question

List licenselist = new List (); How to convert the list to the data table.I have a list how to append my list to a data table .

Ananth G · Answer

public partial class Form1 : Form { public Form1() { InitializeComponent(); List ad > obj = new List ad > (); obj.Add(new ad { Name = ss }); DataTable dt = obj .ToDataTable(); } } internal class ad { public string Name { get; set; } } public static class ExtensionMethod { public static DataTable ToDataTable T > (this List T > iList) { DataTable dataTable = new DataTable(); PropertyDescriptorCollection propertyDescriptorCollection = TypeDescriptor .GetProperties(typeof(T)); for (int i = 0 ; i propertyDescriptorCollection.Count ; i++) { PropertyDescriptor propertyDescriptor = propertyDescriptorCollection [i]; Type type = propertyDescriptor .PropertyType; if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable > )) type = Nullable .GetUnderlyingType(type); dataTable.Columns.Add(propertyDescriptor.Name type); } object[] values = new object[propertyDescriptorCollection.Count]; foreach (T iListItem in iList) { for (int i = 0 ; i values.Length ; i++) { values[i] = propertyDescriptorCollection[i].GetValue(iListItem); } dataTable.Rows.Add(values); } return dataTable; } } Define this method to another class like above code.. above code is execution sample its working fine

Ananth G · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; add above reference

Ananth G · Answer

DataTable dt = YourList.ToDataTable(); public static DataTable ToDataTable ( this List iList) { DataTable dataTable = new DataTable(); PropertyDescriptorCollection propertyDescriptorCollection = TypeDescriptor.GetProperties( typeof (T)); for ( int i = 0; i { PropertyDescriptor propertyDescriptor = propertyDescriptorCollection[i]; Type type = propertyDescriptor.PropertyType; if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof (Nullable )) type = Nullable.GetUnderlyingType(type); dataTable.Columns.Add(propertyDescriptor.Name type); } object [] values = new object [propertyDescriptorCollection.Count]; foreach (T iListItem in iList) { for ( int i = 0; i { values[i] = propertyDescriptorCollection[i].GetValue(iListItem); } dataTable.Rows.Add(values); } return dataTable; } Ur list List licenselist = new List (); DataTable dt = licenselist.ToDataTable();

Harshal Patil · Answer

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 { //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; }

Jasbeer Singh · Answer

You ca use this method to get Datatable from list. You can pass list to this function

Khaja Moizuddin · Answer

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; }

Midhun T P · Answer

Hi Please go through below article - http://www.c-sharpcorner.com/UploadFile/1a81c5/list-to-datatable-converter-using-C-Sharp/

Dinesh Santhalingam · Answer

Ananth There is an error populating in my code . Error 5 Extension method must be defined in a non-generic static class

Dinesh Santhalingam · Answer

Ananth PropertyDescriptorCollection shows an error-Missing assembly reference