Tuesday, October 9, 2012

Dynamic Create DataTable in Asp.net


       private DataTable CreateTable()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Id", Type.GetType("System.Int32"));
            dt.Columns.Add("Name", Type.GetType("System.String"));
            return dt;
        }
                public void Bind()
        {
            list = objDAL.GetALLData();
            DataTable dt = CreateTable();
            for (int i = 0; i < list.Count; i++)
            {
                    DataRow dr = dt.NewRow();
                    dr["Id"] = list[i].Id;
                    dr["Name"] = list[i].Name;
                    dt.Rows.Add(dr);
            }
            DataView dv = dt.DefaultView;
            dv.Sort = "Name";
            dt = dv.ToTable();
            if (dt.Rows.Count > 0)
            {
                rptEvent.DataSource = dt;
                rptEvent.DataBind();
                dt.Dispose();
            }
        }        

No comments:

Post a Comment