Saturday, 29 July 2017

Convert DataTable to List


Create DataTable:
private void tempattributetable()
        {
            DataTable dt = new DataTable();

            dt.Columns.Add("Image_Path "typeof(int));
            dt.Columns.Add("ItemDetail_ID "typeof(string));
            dt.Columns.Add("IsDefaultImage "typeof(string));
            Session["dt"] = dt;

        }
Create Class:
public class MyType
        {
            public string Image_Path { get; set; }
            public int ItemDetail_ID { get; set; }
            public bool IsDefaultImage { get; set; }
        } 
Convert DataTable to List:

private void BindGrid()
{
DataTable dtimg = (Session["dt"]) as DataTable;
                    List<MyType> list = new List<MyType>();

                    var imgList = (from DataRow dr in dtimg.Rows
                                   select new MyType()
                                   {
                                       Image_Path = dr["Image_Path"].ToString(),
                                       ItemDetail_ID = Convert.ToInt32(dr["ItemDetail_ID"].ToString()),
                                       IsDefaultImage = Convert.ToBoolean(dr["IsDefaultImage"].ToString())
                                   }).ToList();
   if (imgList.ToList().Count > 0)
                    {
                        img.Visible = true;
                        img.DataSource = imgList.ToList();
                        img.DataBind();
                    }
}

No comments:

Post a Comment