how to convert DataTable to List dynamically

Question

Can Anyone suggest me how to convert DataTable to List<> dynamically ?

I need a function where if I pass class name or object of class with dataTable that function should return List<Object_Of_Class_Pass_In_Function>.

Ex :

Public List<xy> ChnageDtToList(DataTable dt, <Here Dynamic Object Of Any Custom Class say xy>)

{

//

Return List<xy>

}

How to create above function ?

Rahul Singh · Answer

Hi Manish I have created this generic method to convert a datatable to generic list. Hope this the solution you were looking for. private static List ConvertDataTable (DataTable dt) { List data = new List (); foreach (DataRow row in dt.Rows) { T item = GetItem (row); data.Add(item); } return data; } private static T GetItem (DataRow dr) { Type temp = typeof(T); T obj = Activator.CreateInstance (); foreach (DataColumn column in dr.Table.Columns) { foreach (PropertyInfo pro in temp.GetProperties()) { if (pro.Name == column.ColumnName) pro.SetValue(obj dr[column.ColumnName] null); else continue; } } return obj; } I have attached the sample code too do let me know if that helped.

Abhishek Singh · Answer

Manish  Please follow the below article . http://www.codeproject.com/Tips/784090/Conversion-Between-DataTable-and-List-in-Csharp Hope this help you. Abhishek

laxman lucky · Answer

convert DataTable to List dynamically When your passing the value you can use this pass paramiter or object Do somthing like this.. string connectionString = ConfigurationManager.ConnectionStrings[DBCS].ConnectionString.ToString(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(Your seleting procedure name con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); var Reader = cmd.ExecuteReader(); var Result = Reader.Cast ().Select(r => new Selecting_Entity (List Name) { Firstname= (string)r[FIRSTNAME] Lastname = (string)r[LASTNAME] Phonenumber= (int)r[PHONENUM] }).ToList(); return Result; } Do like this I hope it will help you. Thanks Laxman M