private void loadgrid()
{
DataTable dt = new DataTable();
DataTable _dt1 = new DataTable();
DataTable _dt2 = new DataTable();
DataTable _dt3 = new DataTable();
DataTable _dt4 = new DataTable();
//Create an ID column for adding to the Datatable
DataColumn dcol = new DataColumn("Lecture#", typeof(System.String));
DataColumn dcol1 = new DataColumn("Lecture#", typeof(System.String));
DataColumn dcol2 = new DataColumn("Lecture#", typeof(System.String));
DataColumn dcol3 = new DataColumn("Lecture#", typeof(System.String));
DataColumn dcol4 = new DataColumn("Lecture#", typeof(System.String));
dt.Columns.Add(dcol);
_dt1.Columns.Add(dcol1);
_dt2.Columns.Add(dcol2);
_dt3.Columns.Add(dcol3);
_dt4.Columns.Add(dcol4);
//Create an ID column for adding to the Datatable
for (int i = 1; i <= 28; i++)
{
dcol = new DataColumn(i.ToString(), typeof(System.String));
dcol1 = new DataColumn(i.ToString(), typeof(System.String));
dcol2 = new DataColumn(i.ToString(), typeof(System.String));
dcol3 = new DataColumn(i.ToString(), typeof(System.String));
dcol4 = new DataColumn(i.ToString(), typeof(System.String));
dt.Columns.Add(dcol);
_dt1.Columns.Add(dcol1);
_dt2.Columns.Add(dcol2);
_dt3.Columns.Add(dcol3);
_dt4.Columns.Add(dcol4);
}
//Now add data for dynamic columns
//As the first column is auto-increment, we do not have to add any thing.
//Let's add some data to the second column.
//Create a new row
DataRow drow = dt.NewRow();
DataRow _drow1 = _dt1.NewRow();
DataRow _drow2 = _dt2.NewRow();
DataRow _drow3 = _dt3.NewRow();
DataRow _drow4 = _dt4.NewRow();
//Initialize the row data.
//Add the row to the datatable.
BLItem objBL = new BLItem();
DataTable dt1 = objBL.get_courses_from_attendance(Session["New"].ToString());
int count = 0;
foreach (DataRow row in dt1.Rows) // parse each row of datatable
{
if (!row["courseName"].ToString().Equals(DBNull.Value)) // check if ItemNo is not null
{
if (count == 0)
{
Head1.Visible = true;
Head1.Text = row["courseName"].ToString();
DataTable dt2 = objBL.get_lectures_from_Attendance(Session["New"].ToString(), row["courseID"].ToString(), row["sectionID"].ToString());
foreach (DataRow row2 in dt2.Rows)
{
for (int i = 1; i <= 28; i++)
{
if (i.ToString() == row2["lectureNo"].ToString())
{
drow[i.ToString()] = "A";
}
else
{
if (drow[i.ToString()].ToString() != "A")
{
drow[i.ToString()] = "-";
}
}
}
}
dt.Rows.Add(drow);
grd.DataSource = dt;
grd.DataBind();
}
if (count == 1)
{
Head2.Visible = true;
Head2.Text = row["courseName"].ToString();
DataTable dt2 = objBL.get_lectures_from_Attendance(Session["New"].ToString(), row["courseID"].ToString(), row["sectionID"].ToString());
foreach (DataRow row2 in dt2.Rows)
{
for (int i = 1; i <= 28; i++)
{
if (i.ToString() == row2["lectureNo"].ToString())
{
_drow1[i.ToString()] = "A";
}
else
{
if (_drow1[i.ToString()].ToString() != "A")
{
_drow1[i.ToString()] = "-";
}
}
}
}
_dt1.Rows.Add(_drow1);
grd1.DataSource = _dt1;
grd1.DataBind();
}
if (count == 2)
{
Head3.Visible = true;
Head3.Text = row["courseName"].ToString();
DataTable dt2 = objBL.get_lectures_from_Attendance(Session["New"].ToString(), row["courseID"].ToString(), row["sectionID"].ToString());
foreach (DataRow row2 in dt2.Rows)
{
for (int i = 1; i <= 28; i++)
{
if (i.ToString() == row2["lectureNo"].ToString())
{
_drow2[i.ToString()] = "A";
}
else
{
if (_drow2[i.ToString()].ToString() != "A")
{
_drow2[i.ToString()] = "-";
}
}
}
_dt2.Rows.Add(_drow2);
}
_dt2.Rows.Add(_drow2);
grd2.DataSource = _dt2;
grd2.DataBind();
}
if (count == 3)
{
Head4.Visible = true;
Head4.Text = row["courseName"].ToString();
DataTable dt2 = objBL.get_lectures_from_Attendance(Session["New"].ToString(), row["courseID"].ToString(), row["sectionID"].ToString());
foreach (DataRow row2 in dt2.Rows)
{
for (int i = 1; i <= 28; i++)
{
if (i.ToString() == row2["lectureNo"].ToString())
{
_drow3[i.ToString()] = "A";
}
else
{
if (_drow3[i.ToString()].ToString() != "A")
{
_drow3[i.ToString()] = "-";
}
}
}
_dt3.Rows.Add(_drow3);
}
_dt3.Rows.Add(_drow3);
grd3.DataSource = _dt3;
grd3.DataBind();
}
if (count == 4)
{
Head5.Visible = true;
Head5.Text = row["courseName"].ToString();
DataTable dt2 = objBL.get_lectures_from_Attendance(Session["New"].ToString(), row["courseID"].ToString(), row["sectionID"].ToString());
foreach (DataRow row2 in dt2.Rows)
{
for (int i = 1; i <= 28; i++)
{
if (i.ToString() == row2["lectureNo"].ToString())
{
_drow4[i.ToString()] = "A";
}
else
{
if (_drow4[i.ToString()].ToString() != "A")
{
_drow4[i.ToString()] = "-";
}
}
}
}
_dt4.Rows.Add(_drow4);
grd4.DataSource = _dt4;
grd4.DataBind();
}
count++;
}
}
}