How to convert List to Datatable?

Total Post:119

Points:835
C#  ASP.Net 
 1242  View(s)
Ratings:
Rate this:
how to convert list to datatable in asp.net.
  1. Post:128

    Points:898
    Re: How to convert List to Datatable?


    Hi Goti please visit this example

    public static DataTable ToDataTable<T>(List<T> items)
    {
            DataTable dataTable = new DataTable(typeof(T).Name);
        PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
            foreach (PropertyInfo prop in Props)
            {
                dataTable.Columns.Add(prop.Name);
            }
            foreach (T item in items)
            {
               var values = new object[Props.Length];
               for (int i = 0; i < Props.Length; i++)
               {
                    values[i] = Props[i].GetValue(item, null);
               }
               dataTable.Rows.Add(values);
          }
          return dataTable;
    }

      Modified On Apr-06-2018 01:11:44 AM

Answer