Loading

How to search a record from database by date range.

ZAIN ULARIFEEN

Hi
I have one column called date in database and my database datecolumn contain like this 2013-02-22,but in front end iam using 2 ajaxdate pickers and searching for a record
i am writing the query like this,i want to know whether it is correct or not
SELECT * from table where Date between ='" + txtfromdate.Text + "and" +txttodate +"'";

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreejesh SP13y ago
Dear zain,

Sql date format difference in c# date format ,so first u change c# date format to sql then Apply your query,that date column is string so ur query is correct,so check ur table

thanks

Sreejesh
0
Rajneesh Rai13y ago
Hi Zain
use

SELECT * from table where Date between '" + txtfromdate.Text + "' and '" +txttodate.Text +"'";

Mark this as accepted answer if your problem solved.
0