private void BindGrid() { DataTable sourcedt = new DataTable(); if (Session["dsTemp"] != null) { dsTemp = (DataSet)Session["dsTemp"]; DataTable maindata = new DataTable(); DataTable dt = new DataTable(); maindata = dsTemp.Tables[0]; DataTable disemployees = new DataTable(); disemployees = maindata.DefaultView.ToTable(true, "F_Tbl_Emp_Code", "F_Emp_FirstName"); sourcedt = maindata.DefaultView.ToTable(true, "F_Tbl_Emp_Code", "F_Emp_FirstName"); distdates = maindata.DefaultView.ToTable(true, "Dt_Punched"); datecount = distdates.Rows.Count; startdate = Convert.ToDateTime(distdates.Rows[0][0].ToString()); for (int i = 0; i <= distdates.Rows.Count; i++) { string colhead = DateTime.Today.AddDays(i).ToShortDateString(); sourcedt.Columns.Add(new DataColumn("", typeof(String))); sourcedt.Columns.Add(new DataColumn("", typeof(String))); sourcedt.Columns.Add(new DataColumn("", typeof(String))); } DataTable dtdata = new DataTable(); foreach (DataRow mr in sourcedt.Rows) { DataView view2 = new DataView(maindata, "F_Tbl_Emp_Code=" + mr["F_Tbl_Emp_Code"].ToString(), "", DataViewRowState.CurrentRows); dtdata = view2.ToTable(); int l = 2; int m = 3; foreach (DataRow dr in dtdata.Rows) { mr[l] = dr[m].ToString(); l++; mr[l] = dr[m + 1].ToString(); l++; mr[l] = dr[m + 2].ToString(); l++; m = 3; } } GridView_Merge_Header.DataSource = sourcedt; GridView_Merge_Header.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable maindata = new DataTable(); DepartmentDAL Dept = new DepartmentDAL(); DataTable dt = new DataTable(); maindata = Dept.getpivot(); DataTable sourcedt = new DataTable(); DataTable disemployees = new DataTable(); disemployees = maindata.DefaultView.ToTable(true, "F_Tbl_Emp_Code", "F_Emp_FirstName"); sourcedt = maindata.DefaultView.ToTable(true, "F_Tbl_Emp_Code", "F_Emp_FirstName"); distdates = maindata.DefaultView.ToTable(true, "Dt_Punched"); datecount = distdates.Rows.Count; startdate = Convert.ToDateTime(distdates.Rows[0][0].ToString()); for (int i = 0; i <= distdates.Rows.Count; i++) { string colhead = DateTime.Today.AddDays(i).ToShortDateString(); sourcedt.Columns.Add(new DataColumn("", typeof(String))); sourcedt.Columns.Add(new DataColumn("", typeof(String))); sourcedt.Columns.Add(new DataColumn("", typeof(String))); } DataTable dtdata = new DataTable(); foreach (DataRow mr in sourcedt.Rows) { DataView view2 = new DataView(maindata, "F_Tbl_Emp_Code=" + mr["F_Tbl_Emp_Code"].ToString(), "", DataViewRowState.CurrentRows); dtdata = view2.ToTable(); int l = 2; int m = 3; foreach (DataRow dr in dtdata.Rows) { mr[l] = dr[m].ToString(); l++; mr[l] = dr[m + 1].ToString(); l++; mr[l] = dr[m + 2].ToString(); l++; m = 3; } } GridView_Merge_Header.DataSource = sourcedt; GridView_Merge_Header.DataBind(); } }