SqlDataAdapter da1 = new SqlDataAdapter("select * from bill_detail where Date BETWEEN '" + dt1 + "' AND '" + dt2 + "'", con);
select * from bill_detail where Date >= '" + dt1 + "' AND Date <= '" + dt2 + "'"
SELECT * FROM bill_detail WHERE Date BETWEEN cast('" + dt1 + "' as DATETIME) AND CAST('" + dt2 + "' as DATETIME)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)