private void FillGrid(DateTime Start, DateTime End)
{
dsAttendance ds = new dsAttendance();
dsAttendanceTableAdapters.AttendanceTableAdapter taAttendance = new dsAttendanceTableAdapters.AttendanceTableAdapter();
DataTable dt = taAttendance.GetDataByGivenDates(Start.ToString(), End.ToString());
grdAttendanceList.Rows.Clear();
grdAttendanceList.AutoGenerateColumns = false;
int SrNo = 0;
foreach (DataRow item in dt.Rows)
{
SrNo++;
DateTime date = Convert.ToDateTime(item[1].ToString());
string Day = date.ToString("dddd");
string Month = date.ToString("MMMM");
grdAttendanceList.Rows.Add(item[0], SrNo, date.ToString("dd,MMMM,yyyy"), Day, Month);
}
tbxCount.Text = SrNo.ToString();
}
