using multiple datetimepicker in c# with MySql

private void loadData()
{ if (DtFrom.Value == DtTo.Value)
{
MessageBox.Show("Please Select Employee name and Valid Dates", "DTR");

}
else if (DtFrom.Value >= DtTo.Value)

{ MessageBox.Show("Please Select Employee name and Valid Dates", "DTR");

}
else
{
cnn.cmdOpen(cmdForm);
cmdForm.CommandText = " SELECT attendance.work,attendance.in_, attendance.out_,attendance.weekday," + "attendance.date,employee.Empname,employee.Empno" + " FROM employee LEFT JOIN attendance ON employee.biomitricno = attendance.badgeno WHERE date >='" + DtFrom.Value.ToString() + "' AND date <='" + DtTo.Value.ToString() + "'";

MySqlDataAdapter da = new MySqlDataAdapter();

da.SelectCommand = cmdForm;

DataTable dtble = new DataTable();
da.Fill(dtble);
BindingSource bSource = new BindingSource();
bSource.DataSource = dtble;

dgVMonthly.DataSource = bSource;
cmdForm.Dispose();
cnn.cn.Close();

}

}



heres the complate code, the only problem is cannot load the date from 1 to 10 (example: 11/01/2013 to 11/09/2013) from 11 to ..... its working fine

hi Alex,

You can prompt user to enter second date, which is greater than first date.
For this you can check whether Second date is greater than first, if not then you can ask him to select date greater than first. As it will save your time. This will help you to avoid unnecessary connection to database.

e.g

DateTime date1 = new DateTime(2009, 8, 1, 0, 0, 0);
DateTime date2 = new DateTime(2009, 8, 1, 12, 0, 0);

int result = DateTime.Compare(date1, date2);

string relationship;
if (result < 0)

relationship = "is earlier than";

else if (result == 0) relationship = "is the same time as";

else relationship = "is later than";