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

Question

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

znaneswar kodavanti · Answer

Thanks its working now.

Vulpes · Answer

Try enclosing it with hashes: string st = Select attandence.IDlastname from studentattandence WHERE attandence.inouttime = # + dt.ToString() + # and attandence.id=student.id and attandence.inout=1;