date range search

[Kunal P]

hi i wanted to perform a search for records based on the date range specified by the user.. the input method is by way of calender extender(Ajax toolkit) which is in mm/dd/yyyy before going to the web from i just queried the table using the query builder and it constructed a query SELECT patient.* FROM patient WHERE (Dt BETWEEN CONVERT(DATETIME, '2006-08-09 00:00:00', 102) AND CONVERT(DATETIME, '2006-09-09 00:00:00', 102)) now how do i use the same query to the webform... also how will i display the results in a gridview control.. thx

Kunal