C# .NET - how to check date count in mysql - Asked By abinav shankar on 31-Jan-12 06:15 AM

Hi

I want to check whether a person has applied for leave today for that i am passing datetime.now as parameter but i am getting null as result but there records already exists in the table how to check it

smr replied to abinav shankar on 31-Jan-12 06:16 AM
hi

try this

DateTime minDate = DateTime.MaxValue;
DateTime maxDate = DateTime.MinValue;
foreach (string dateString in StringDates)
{
  DateTime date = DateTime.Parse(dateString);
  if (date < minDate)
    minDate = date;
  if (date > maxDate)
    maxDate = date;
}
Jitendra Faye replied to abinav shankar on 31-Jan-12 06:18 AM
First convert both date  (Front end and back end ) to dateFormat, because comparision can be done only between same format.

Try and let me know.
Venkat K replied to abinav shankar on 31-Jan-12 06:20 AM
How you are checking the date? In which format you are storing date in my sql db?

Have you tried in this format?
SELECT * FROM EMPLOYEE1 WHERE DAT ='2008-12-01'

or you can use the DATE_FORMAT to convert the date value to the required value, with the option specified in the below link:

http://davidwalsh.name/format-date-mysql-date_format

Thanks

dipa ahuja replied to abinav shankar on 31-Jan-12 06:23 AM
Check the dataTime column with this query:


string q= "Select Count(*) from table1 where ename='" + TextBox1.Text + "' AND leaveDate='" + DateTime.Now.ToShortDateString() +"'" ;

Now bind it with dataAdapter and DAtaTable and check the rows count if its > 0 means this person have taken the leave