[yangma]

 cmd = New SqlCommand("select * from employee_log where log_datetime >='" + DateTimePicker1.Value.Date + "'   And  log_datetime<= '" + DateTimePicker2.Value.Date + "'	", cn)

suppose if i select two dates june 21 and june 30 then records between 21 and 30 including 21 and 30 should be shown..but the records of june 30 is not shown..only from 21 to 29 is shown by this code...
wat should i add or edit to this code??thanks

[noorahmad]

simply use

cmd = New SqlCommand("select * from employee_log where log_datetime Between '" + DateTimePicker1.Value.Date + "'   And  '" + DateTimePicker2.Value.Date + "'    ", cn)

Let Know it Was Help Full

[yangma]

that results same as above .....last date is not showing