Hi i have a problem with c# to get date and time with ms access

when am passing like this am getting output correctly
string st = "Select attandence.ID,lastname from student,attandence WHERE attandence.inouttime = '5/18/2012' and attandence.id=student.id and attandence.inout=1";

but when am passing the date as a string or datetime format am not getting the any output
string dt = dateTimePicker1.Value.ToShortDateString();
string st = "Select attandence.ID,lastname from student,attandence WHERE attandence.inouttime = " + dt.ToString() + " and attandence.id=student.id and attandence.inout=1";

i also tried dt only at the place of dt.ToString() but am not getting
in my msaccess file i tested the date field with both text and date time.
But not get the output
please help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

znaneswar kodavanti14y ago
Thanks its working now.
Vulpes14y ago
Try enclosing it with hashes:

string st = "Select attandence.ID,lastname from student,attandence WHERE attandence.inouttime = #" + dt.ToString() + "# and attandence.id=student.id and attandence.inout=1";