how to convert DataTable to List<> dynamically

Manish Kumar Choudhary

12y22.3k.NET

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.

Ex :

Public List ChnageDtToList(DataTable dt, xy>)

{

Return List

}

How to create above function ?

3 Replies

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

Rahul Singh11y ago
Accepted 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.
0
Abhishek Kumar11y ago
Manish ,

Please follow the below article .

http://www.codeproject.com/Tips/784090/Conversion-Between-DataTable-and-List-in-Csharp

Hope this help you.

Abhishek
0
laxman lucky11y ago
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,

0