Date Range to populate a datagrid (VB 2005)? 1

[bburnell]

Is there a way to allow a user to specify a date range and then populate a dataset/datagrid with that information in VB.net 2005? I am currently using a combobox that populates the datagrid based on what the user has selectedx in said combobox and it is working fine. Can a dataset use two "?"s to populate? Could I call a stored procedure and then populate it based on those results (and how?) Any help would be greatly appreciated.
Thanks!
Brett

P.S. I am using SQL Server 2005 to call the data from.

 

[jbenson001]

Use a stored procedure.. you can use multiple parameters. You can all the SP with a command object or sqldatadapter. There are many examples in the VSHelp files and here. Also search on Google.

 

[bburnell]

Thank you! Now I just have to figure out the code. I appreciate it!
Brett

 

[jbenson001]

No problem.. give it a shot and post back with any problems.

 

[bburnell]

This sample worked well for me.

http://msdn2.microsoft.com/en-us/library/2f8abfew(VS.80).aspx

Thanks again!
~Brett

 

[jbenson001]

great.. glad you found a good example that helps
Jim