SqlDataSource and Control problem

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SelectParameters and SqlDataSource question 2
.Net 2.0 SqlDataSource and DataSet question 1
SqlDataSource and DataSet question 2
SQLDataSource query 3
Getting an Output Parameter from a SqlDataSource 1
SqlDataSource control activating on button click 2
Three (3) Tier architecture and .NET design mode 3
modify SqlDataSource parameters in code behind? 2

Top