Loading

I need from and To dates query in sql server 2005,

Prabhakar Reddy

14y3.5k

Hi To All,
Am new to .net pls help to me,
I need From-TO dates query in Sql Server 2005, i have two textboxs, based on that textbox date values i need to display events to the user.

4 Replies

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

Naresh Avari14y ago
Accepted answer
Hi,

If you have two textboxes called as txtStartDate and txtEndDate.

DateTime startDate = Convert.ToDateTime(txtStartDate.Text);
DateTime endDate = Convert.ToDateTime(txtEndDate.Text);
SqlConnection con = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("SELECT * from tblEvents WHERE eventDate BETWEEN '" + startDate + "' AND '" + endDate + "'", con);

Hope this helps you...
0
Hemant Kumar14y ago
you are welcome :-)
Mark as "Accepted Answer" if it helps you .
0
Prabhakar Reddy14y ago
Thank You, Thank You so much..
0
Hemant Kumar14y ago
Hi Prabhakar,

Try this Query

select * from tbl_abc where trunc(StartTime) between to_date('2009-07-15',
'YYYY-MM-DD') and to_date('2009-07-16', 'YYYY-MM-DD');

Do refer this link for Getting the data based on the To and From Dates in SQL SERVER
http://www.aspdotnet-suresh.com/2012/08/query-to-get-data-between-two-dates-in.html
0