| Author: Athira Appukuttan 02 Sep 2008 | Member Level: Diamond | Rating:  Points: 3 |
public DataTable CreateAttendanceHeader()
{
string sMonth = drpMonth.SelectedValue;
string sYear = drpYear.SelectedValue;
int iTotalDays = DateTime.DaysInMonth(Convert.ToInt32(sYear), Convert.ToInt32(sMonth));
DataTable dtAttendance = new DataTable();
DataColumn dcol = new DataColumn("Month", typeof(System.String));
dtAttendance.Columns.Add(dcol);
for (int nIndex = 1; nIndex <= iTotalDays; nIndex++)
{
dcol = new DataColumn(Convert.ToString((nIndex)));
dtAttendance.Columns.Add(dcol);
}
dcol = new DataColumn("Total Working Days", typeof(System.String));
dtAttendance.Columns.Add(dcol);
dcol = new DataColumn("Total Worked Days", typeof(System.String));
dtAttendance.Columns.Add(dcol);
dcol = new DataColumn("Total Leave Days", typeof(System.String));
dtAttendance.Columns.Add(dcol);
dcol = new DataColumn("Total Missed Days", typeof(System.String));
dtAttendance.Columns.Add(dcol);
DataRow dRow = dtAttendance.NewRow();
string sDate = sMonth + "/" + "1" + "/" + sYear;
DateTime dtDate = Convert.ToDateTime(sDate);
dRow["Month"] = dtDate.ToString("MMM") + "-" + sYear;
dtAttendance.Rows.Add(dRow);
return dtAttendance;
//DayOfWeek dow = dtDate.DayOfWeek;
}
button click:
DataTable dtReport = CreateAttendanceHeader();
grdAttendance.DataSource = dtReport;
grdAttendance.DataBind();
|