The WHERE selectCommand with two DDL selected values of the SqlDataSouirce did not work, can not open the FormView control.

Question

User-830563764 posted

In a VS2010 ASP.NET 4 webpage, I have had 2 DDL's to select an ID and a County.
The SqlDataSource with selectCommand WHERE ID=@ID or County = @COUNTY
worked fine respectively. 

However, when I added both together in the SqlDataSource as ID=@ID and
County = @COUNTY,  the FormView control was not displayed.  Clicking the
DDL's did not open up the FormView control.

Why?

Answer 1

User-1780421697 posted

I think when things are getting complicated then you need to use some sort of stored procedure or custom made ad-hoc query or what so ever you like which make the code easier in long terms and maintenance will be easy.

Take parameters from any number of ddls and pass to your stored procedure and populate control accordingly you need to manage events by yourself.

Answer 2

User36583972 posted

Hi wonjartran,

I suggest you can check your problem as the following options.

1: Check your sql query returns the correct value. In database sql query editor, you can check your sql query.

2: Debug your code (DDL click event) and find whether a mistake in your program

3: You could also share us more relevant code to help us reproduce the problem.

Best Regards,

Yohann Lu

Answer 3

User-830563764 posted

I think it is very possible that there is no data can be selected for the both WHERE commands. 

Answer 4

User36583972 posted

Hi wonjartran,

I think it is very possible that there is no data can be selected for the both WHERE commands. 

In database sql query editor, you can check your sql query. Then, adjust your statement or design logic. We can debug step by step to find which reason cause the error.

Best Regards,

Yohann Lu