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)