I've got a web form that I need to make the selection criteria combo boxes dynamic.
There are 4 combo boxes and they all need to dynamic.
--- ANALOGY ---
So, if cboMonth is set to August, then all of the other combo boxes have to have Month = August as the Where Clause.
Then, if cboYear is set to 2007, then all of the other combo boxes have to have Month = August and Year = 2007 as the Where Clause.
The exact same where clause will apply to all 4 combo boxes.
--- ACTUAL SCOPE ---
The exact details are detailed in the attached word document.
Note - database and SQL statements are all provided. The aspx web form is provided with the combo boxes in place and the proper SQL statement (less the WHERE claue) included. I just need someone to be able to change the SQL statement feeding all four combo boxes every time one of the combo boxes is change.
I'm thinking if you can
1- create a function to create a where clause based upon each of the values that is not null
2 - set the results of that function to a variable-WHERE (this will be blank initially).
3 - include variable-WHERE in all 4 of the combo box's select statements.
Note - that I do not know HOW to do this - so it may not be this simple. That's why I want to hire YOU
接包方 | 国家/地区 | |
---|---|---|
4
Hfeeki
|
||
3
Dr_ram
|
||
3
Outsourcingcenter
|
||
3
Relay14
|
||
3
Daimler250v8
|
||
3
Torontowebservices
|
||
3
Facebookguru
|
||
2
Leigao
|
||
2
Baltimoreshawn
(中标)
|
||
2
Mscrmexperts
|
||
2
Iphone_cocoa
|