search between two date and bind data in grid view

Question

how to bind data between two date in c#

 i use this query 

 

select * FROM Tbl_Work

INNER JOIN

Tbl_Client ON Tbl_Work.Client_Id = Tbl_Client.Client_Id

INNER JOIN

Tbl_Department ON Tbl_Work.Department_Id = Tbl_Department.Department_Id

where

Tbl_Work.Client_Id=@Client_Id

and

Tbl_Work.Department_Id=@Department_Id

and

Tbl_Work.Start_Date BETWEEN CONVERT(VARCHAR(10),@Start_Date,103)

AND

CONVERT(VARCHAR(10),@Start_Date,103)

 

Answer 1

Hi, try like SELECT * FROM #temp WHERE CONVERT(VARCHAR(10),CrDate,103) BETWEEN CONVERT(VARCHAR(10),'07/08/2012',103) AND CONVERT(VARCHAR(10),'10/08/2012',103) Check out below links http://www.aspdotnet-suresh.com/2012/08/query-to-get-data-between-two-dates-in.html?m=1 http://stackoverflow.com/questions/11382423/how-to-display-the-search-results-based-on-two-dates-in-the-listview