Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Iain Duthie
Starting Member
17 Posts |
 Posted - 2005-02-21 : 09:06:20
|
| I have two drop down lists on one of my pages that need to be linked. One of them contains group codes and the other contains areas. Certain areas correspond to certain group codes. What I want is if a user selects a group code I want the area drop down list to show only the areas corresponding to that selected group code. Can this be done.CheersIain. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-21 : 09:19:19
|
yes it can.when a group changes put a filter on a dataview/datatable source of the areas ddl.EDIT: if you wan't it without the postback you must use clientside JavaScript and filter it there.Go with the flow & have fun! Else fight the flow  |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-02-22 : 22:49:02
|
quote:
Originally posted by spirit1
yes it can.when a group changes put a filter on a dataview/datatable source of the areas ddl.EDIT: if you wan't it without the postback you must use clientside JavaScript and filter it there.Go with the flow & have fun! Else fight the flow
Why not just use a stored procedure and pass in a GroupID ?Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-22 : 23:45:42
|
quote:
Why not just use a stored procedure and pass in a GroupID ?Jon
Certainly that would work, but if the data is reletively static, you can avoid the trip to the DB by caching the dataset.-Chadhttp://www.phxpoker.comPhoenix's largest online poker community |
|
|
|
|
|
|
Drop Down Lists