How to convert a list into data table

Question

I have a data list with some property  I want to convert that list data into data table  How to convert a list into datable

User · Answer

you can use this extension method and call it like this    DataTable dt     YourList ToDataTable     public static DataTable ToDataTable lt T gt  this List lt T gt  iList                        DataTable dataTable   new DataTable                PropertyDescriptorCollection propertyDescriptorCollection                   TypeDescriptor GetProperties typeof T                for  int i   0  i  lt  propertyDescriptorCollection Count  i                                  PropertyDescriptor propertyDescriptor   propertyDescriptorCollection i                   Type type   propertyDescriptor PropertyType                   if  type IsGenericType  amp  amp  type GetGenericTypeDefinition      typeof Nullable lt  gt                        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  lt  values Length  i                                          values i    propertyDescriptorCollection i  GetValue iListItem                                     dataTable Rows Add values                             return dataTable

User · Answer

Just add this function and call it  it will convert List to DataTable   public static DataTable ToDataTable lt T gt  List lt T gt  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                          Defining type of data column gives proper data table              var type    prop PropertyType IsGenericType  amp  amp  prop PropertyType GetGenericTypeDefinition      typeof Nullable lt  gt     Nullable GetUnderlyingType prop PropertyType    prop PropertyType                 Setting column names as Property names             dataTable Columns Add prop Name  type                     foreach  T item in items                       var values   new object Props Length              for  int i   0  i  lt  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

User · Answer

private DataTable CreateDataTable IList lt T gt  item        Type type   typeof T       var properties   type GetProperties         DataTable dataTable   new DataTable        foreach  PropertyInfo info in properties                dataTable Columns Add new DataColumn info Name  Nullable GetUnderlyingType info PropertyType     info PropertyType               foreach  T entity in item                object   values   new object properties Length           for  int i   0  i  lt  properties Length  i                          values i    properties i  GetValue entity                      dataTable Rows Add values             return dataTable

[c#] How to convert a list into data table

Examples related to c#

Examples related to asp.net