how will i convert data table to collection?

Shailendra Verma

dear sir,

i have a data table and now i want to convert it into collection so how i convert data table to collection?

Thanks

Shailendra

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nayeem Mansoori13y ago
Hi ,
the following is the method through which you can convert any list object to datatable..

public DataTable ConvertToDataTable(IList data)
{
PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T));
DataTable table = new DataTable();
foreach (PropertyDescriptor prop in properties)
table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
foreach (T item in data)
{
DataRow row = table.NewRow();
foreach (PropertyDescriptor prop in properties) row[prop.Name] = prop.GetValue(item) ?? DBNull.Value; table.Rows.Add(row);
}
return table;
}
0
Sam Hobbs16y ago
A DataTable already has a collection; no need to create a new one. Just look at the properties of the DataTable class.
0
Suthish Nair16y ago
3.5 framework +
Another simple way..

using System.Collections.Generic;

DataSet ds = new DataSet(); //for example
List list1 = new List(ds.Tables[0].Select());

2.
List list = new List();
foreach (DataRow item in ds.Tables[0].Rows)
{
list.Add(item);
}
0
Manikavelu Velayutham16y ago
There were so many options to do this.
One of the optimized way of doing this is through LINQ.
Below code will help you.
List<MyObject> NewList= new List<MyObject>();

   DataTable dtMyData = new MyTableAdapter().GetMyData();

   NewList= (from l in dtMyData
select new MyObject
{
Active = l.IsActive,
Email = l.Email,
                   ZipCode = l.Zipcode
}).ToList();
0