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 · Accepted 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 Kumar · 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