I know how to fill a dropdown list and use it's selected value as a parameter.
How can I setup 2 columns, hide one column but use the hidden column (a key)
as the parameter

For example:

Prov, ProvID (hidden column)

=====
..SelectedValue.column()....?

You can set the DataValueField and DataTextField properties to match the
properties you want set from the datasource. In this case, the hidden
parameter is the DataValueField. To get it back from the DropDownList after
a PostBack you get SelectedValue. It does work like a GridView where you do
have to hide the key fields to use them as parameters.

Brennan Stehling
http://brennan.offwhite.net/blog/

"jonefer" <jonefer (AT) discussions (DOT) microsoft.com> wrote