Click here to Skip to main content
15,171,873 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have Two textboxes.
If i select date from ajax calenderextender,get data between two dates from database and display in gridview in the below format

Id Name City Count 1/6/2015 2/6/2015 3/6/2015 4/6/2015 5/6/2015 6/6/2015 7/6/2015 8/6/2015 9/6/2015 10/6/2015 Total

I am getting data , I am unable to display date ranges in gridview.

So please help me.
Posted
Comments
Ujjval Shukla 22-Jun-15 7:46am
   
Write some code of your program
Ujjval Shukla 22-Jun-15 7:50am
   
try this-
SELECT *
FROM Events
WHERE EventDate BETWEEN '2015/05/01' AND '2015/05/31'
ZurdoDev 22-Jun-15 8:08am
   
What is your question?

1 solution

See here..

http://www.sqlfiddle.com/#!3/268dc/1[^]
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900