I have a webform running that has a calendar control and a datagrid. I used the data toolbox to drop an oledbDataAdapter on the form (because the book told me too). I then used the Data menu option to generate a dataset (ScheduledCases1), which I built the basic sql query (SQL 2000 for the database). I have the code all working with the data grid getting populated. But I now I need to make a dynamic where clause based on the date they pick in the calendar. So I have to public variables (cStartDate and cEndDate) that stores the date when they click on the calendar. But I don't know how create the dynamic portion of the query. Once I created the dataset with the generate dataset option, is that locked now?

Thanks for any help.

Kirk

I'm using vb.net