SqlDataSource and Control problem

  • Thread starter Thread starter Jason Huang
  • Start date Start date
J

Jason Huang

Hi,

In order to use the paging function coming up with the .Net 2.0's GridView,
I have SqlDataSourceA in my WebForm1. In the WebForm1 I also have 3
DropDownList controls for selecting the Year, Month, and Day.
Now comes my question, how do I config the SqlDataSourceA so that the SELECT
statement will be based on the Year+Month+Day?
I can config SqlDataSource using the SqlDataSource wizard, if the Control is
just one TextBox. But I have no idea how to combine 3 DropDownList controls
as a parameter for a SqlDataSource.
Thanks for help.


Jason
 
Handle the Selecting event of the SqlDataSourceA and add a parameter
concatenating the day/month/year.
 
Back
Top