I need from and To dates query in sql server 2005

Question

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.

Naresh Avari · 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...

Prabhakar Reddy · Answer

Thank You Thank You so much..

Hemant Kumar · Answer

you are welcome :-) Mark as Accepted Answer if it helps you .

Hemant Kumar · Answer

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

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