Help!

[Paul Smith]

I have managed to populate a DropDownList with the fields from a database.

I have managed to capture the users selection - postback.

How do I now use this selection as the parameter for a query which will
return other fields from my database table for the DropDown choice?

I have a query which, in Access, uses the choice as a parameter to produce
the recordset I require, but how do I use this, or indeed is this the best
way to go?

Any code samples would be appreciated.

Paul Smith

 

[Karl Seguin]

Add a parameter to the command object.

Command.Parameters.Add("@Id", OleDbType.Integer).Value = selectedValue

I'd explain more, but this 2 parter does a better job than I could:
http://www.devcity.net/Articles/18/msaccess_sp.aspx
http://www.devcity.net/Articles/34/msaccess_sp2.aspx

Karl