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();
}
}
