List to Datatable Convert

Question

Dear frnds Please any one tell me how to convert list to datatable in asp.net. Thanks & Regards Niranjan Poddar

Rasmita Dash · Answer

I am giving a sample extension function   stands for list type. public static DataTable ListToDataTable (this List DataList) { PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(Type)); DataTable table = new DataTable(); foreach (PropertyDescriptor prop in properties) { table.Columns.Add(prop.Name Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } foreach (Type item in DataList) { DataRow row = table.NewRow(); foreach (PropertyDescriptor prop in properties) row[prop.Name] = prop.GetValue(item) ?? DBNull.Value; table.Rows.Add(row); } return table; }

Dhanunjay Jajimoggla · Answer

Hi Niranjan Poddar  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; }

Abhishek Singh · Answer

Hi here is the code. 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; } Hope this will help. Abhishek