How to search a record from database by date range.

Question

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 +"'";

Sreejesh SP · Answer

Dear zain Sql date format difference in c# date format so first u change c# date format to sql then Apply your querythat date column is string so ur query is correctso check ur table thanks Sreejesh

Rajneesh Rai · Answer

Hi Zain use SELECT * from table where Date between ' + txtfromdate.Text + ' and ' +txttodate.Text +'; Mark this as accepted answer if your problem solved.