Doubt in dynamic input as a date

Posted by Josephmca2012 under C# on 3/14/2012 | Points: 10 | Views : 755 | Status : [Member] | Replies : 1
when i click button and then get from and to date and then display in between data

Joseph Nicholas


Posted by: Sksamantaray on: 3/14/2012 [Member] Silver | Points: 25

From the attachment i understood , by default you need to show all data which will follow no date range.Thereafter you want to give date range and re-populate the gridview. Is it what you required?
If yes , you can create a single strore procedure having fromdate and Todate parameter with default value set to null , so that when you load your page firstime , call the procedure without any parameter which in fact will return all rows. then , in the page after selecting fromdate and todate and click on generate button call the same procedure with fromdate and todate parameter .
Write the stored procedure accordingly .
I think it will solve your problem.


Josephmca2012, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response