Required Sql Query for searching dates FromDate ToDate

Question

1.00/5 (2 votes)

See more:

Dear Friends,

I have Two Text boxes and a Search button on my WebPage.

First Textbox is From - TxtFromDate
Second Textbox is To - TxtDateTo

Search Button - BtnSearch

When user Enters Two dates Such as 30/08/2012 and 15/09/2012 and clicks on Search button. These FromDate DateTo Records must be displayed in Gridview.

Please can u show me how to do this.

Please help help.

By the way I need Sql Query to search the two dates
I think it might be BETWEEN something like that.

Please help .

Thank you Friends.

Posted 30-Aug-12 7:03am

Software Engineer 892

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-08-30T07:09:00

Posted answer to similar question[^] couple of days back:
All you need is a query with search parameters in it that will fetch records. Once fetched, you need to bind them to the grid.

Query would be something like:

SQL

SELECT 
   EmpId, Employeename, JoinDate
FROM
   MyEmployeeTable
WHERE
   JoinDate BETWEEN @FromDate AND @ToDate

ridoy · Answer 2 · 2012-08-30T07:43:00

Solution 2

SQL

SELECT * 
FROM @Orders
WHERE Orderdate BETWEEN @FromDate AND @ToDate

more from..
http://forums.asp.net/t/1434093.aspx/1[^]
http://www.dotnetfunda.com/forums/thread1517-what-is-a-query-to-select-records-between-two-dates.aspx[^]

Posted 30-Aug-12 7:43am

ridoy

User CP · Answer 3 · 2012-08-30T07:58:00

Solution 4

Hi,

The query to fetch the records between two dates is

select * from tableName
where
columnName
between
fromdate
and
Todate

Posted 30-Aug-12 7:58am

User CP

Required Sql Query for searching dates FromDate ToDate

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Required Sql Query for searching dates FromDate ToDate

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us