searching betweent two dates

[Kunal P]

hi i wanted to perform a search for records based on the date range specified by the user.. the input method is in mm/dd/yyyy in the webform 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.. also.. shud i create an stored procedure, by which i can make this possible thx

Kunal

[Christian Graus]

A stored proc is always a better idea. You can just pass a DateTime as a param to a stored proc

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Frank Kerrigan]

like this create proc getrecords @StartDate datetime, @EndDate datetime AS SELECT patient.* FROM patient WHERE (Dt BETWEEN @StartDate AND @EndDate) go

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

[meeram395]

For searching data between two dates, you can also write the query as follows: Suppose that you want to search data between 01/03/2007 and 31/103/2007 Select field1, field2, datefield from tablename where datediff(day,'01/03/2007',datefield) >= 0 and datediff(day,'31/03/2007',datefield) <=0 order by datefield

Meeram395