how will i convert data table to collection?

Question

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

Nayeem Mansoori · Answer

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; }

Suthish Nair · Answer

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); }

Manikavelu Velayutham · Answer

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 ();

Sam Hobbs · Answer

A DataTable already has a collection; no need to create a new one. Just look at the properties of the DataTable class.