Database Strucure as follows in Ms Access
fieldname Datatype
Holiday Datetime
Reason Text
Holiday Reason (table Name Leave) In Ms Access
2/20/2013 Labour Day
2/25/2013 Holiday
Holiday save in tehformat of mm/dd/yyyy (month date year format in the database)
When i select the calendar that month all dates will display in datagridview using csharp.
And also user did not able to select the sunday date in that month.
for the above two condition i written a code as follows;
DGVCalendar.Rows.Clear();
DateTime dt1 = Faculty_Available_Calendar.SelectionStart;
dt1 = new DateTime(dt1.Year, dt1.Month, 1);
DateTime dt2 = dt1.AddMonths(1);
int numDays = (dt2 - dt1).Days;
if (DGVCalendar.RowCount < numDays)
{
DGVCalendar.RowCount = numDays;
}
int row = 0;
while (dt1 < dt2)
{
DGVCalendar.Rows[row].Cells[1].Value = dt1.ToString("dd-MMM-yyyy");
DGVCalendar.Rows[row].Cells[0].Value = true;
if (dt1.DayOfWeek == DayOfWeek.Sunday)
{
DGVCalendar.Rows[row].ReadOnly = true;
DGVCalendar.Rows[row].Cells[0].Value = false;
DGVCalendar.Rows[row].Cells[0].Style.BackColor = Color.Orange;
DGVCalendar.Rows[row].Cells[1].Style.BackColor = Color.Orange;
DGVCalendar.Rows[row].Cells[2].Style.BackColor = Color.Orange;
DGVCalendar.Rows[row].Cells[2].Value = "Sunday";
}
dt1 = dt1.AddDays(1);
row++;
}
I want to check another condition selected date in datagridview is present in another Table.
if user select the 2/20/2013 (the above date in datagridview)
using checkbox user select the 2/20/2013 Date,
shows the message "select date is not allowed"
because the date 2/20/2013 is present in the Leave Table.
For the above condition i written the code as follows;
sql = "select format(Holidaydate,'mmm dd yyyy') as Holdate, [Reason] from Tb_Delcared_Holidays where Holidaydate = '" + DGVCalendar.Rows[row].Cells[1].ToString() + "'";
oledr = GFun.ReadAcessSql(sql);
while (oledr.Read())
{
DGVCalendar.Rows[row].Cells[1].Style.BackColor = Color.Blue;
DGVCalendar.Rows[row].Cells[2].Value = oledr[0].ToString();
}
Because that date is in Leave Table.
When i run shows error as follows;
Invalid attempt to call Read when reader is closed.
from my above in that condition what is the mistake i made.
[Edit]Code block added[/Edit]