How to fill a datatable with List T

Question

How can  convert a list to a datatable   Serializable  public class Item       public string Name   get  set        public double Price   get  set        public string  URL   get  set         public Item string Name  string Price  string  URL                this Name   Name          this Price   Convert ToDouble Price           this  URL    URL             public override string ToString                 return this Name            I tried using   static DataTable ConvertToDatatable List lt Item gt  list        DataTable dt   new DataTable         dt Columns Add  Name        dt Columns Add  Price        dt Columns Add  URL        foreach  var item in list                dt Rows Add item Name  Convert ToString item Price   item URL              return dt      Now I m getting a box show up but its empty  Help   What can i do to make the box actually have data

User · Answer

I also had to come up with an alternate solution  as none of the options listed here worked in my case  I was using an IEnumerable and the underlying data was a IEnumerable and the properties couldn t be enumerated  This did the trick      remove  this  if not on C  3 0    NET 3 5 public static DataTable ConvertToDataTable lt T gt  this IEnumerable lt T gt  data        List lt IDataRecord gt  list   data Cast lt IDataRecord gt    ToList         PropertyDescriptorCollection props   null      DataTable table   new DataTable        if  list    null  amp  amp  list Count  gt  0                props   TypeDescriptor GetProperties list 0            for  int i   0  i  lt  props Count  i                          PropertyDescriptor prop   props i               table Columns Add prop Name  Nullable GetUnderlyingType prop PropertyType     prop PropertyType                       if  props    null                object   values   new object props Count           foreach  T item in data                        for  int i   0  i  lt  values Length  i                                  values i    props i  GetValue item     DBNull Value                            table Rows Add values                       return table

User · Answer

Just in case you have a nullable property in your class object   private static DataTable ConvertToDatatable lt T gt  List lt T gt  data        PropertyDescriptorCollection props   TypeDescriptor GetProperties typeof T        DataTable table   new DataTable        for  int i   0  i  lt  props Count  i                  PropertyDescriptor prop   props i           if  prop PropertyType IsGenericType  amp  amp  prop PropertyType GetGenericTypeDefinition      typeof Nullable lt  gt                table Columns Add prop Name  prop PropertyType GetGenericArguments   0             else             table Columns Add prop Name  prop PropertyType              object   values   new object props Count       foreach  T item in data                for  int i   0  i  lt  values Length  i                          values i    props i  GetValue item                     table Rows Add values             return table

User · Answer

Try this  static DataTable ConvertToDatatable List lt Item gt  list        DataTable dt   new DataTable         dt Columns Add  Name        dt Columns Add  Price        dt Columns Add  URL        foreach  var item in list                var row   dt NewRow             row  Name     item Name          row  Price     Convert ToString item Price           row  URL     item URL           dt Rows Add row              return dt

[c#] How to fill a datatable with List<T>

Examples related to c#

Examples related to ado.net

Examples related to datatable