How can I use a multiselect listbox to pass parameter to a SQL SP

[Jeff Thur]

I have a program where the user does database lookups. I
need to have a listbox where thue user can select one or
more states and a regular textbox to select a last name.
I am not sure how I can do this. I figure that the
programmer must build the criteria from the listbox
itself. Any ideas on how to pass the multiple selections
to a SQL Stored Procedure. The Textbox part is no
problem. Thanks for any help.

 

[Riki]

I have a program where the user does database lookups. I
need to have a listbox where thue user can select one or
more states and a regular textbox to select a last name.
I am not sure how I can do this. I figure that the
programmer must build the criteria from the listbox
itself. Any ideas on how to pass the multiple selections
to a SQL Stored Procedure. The Textbox part is no
problem. Thanks for any help.

First concatenate the values into a string, separated by commas.
Pass this string to your sproc.

Then, in your SQL command, use the IN operator like this:
.... WHERE myField IN (@values) ...

 

[Kostadin Kostov]

Use dataset, and DataAdapter that populates the changes in your dataset to
the database using your stored procedure.

Hope that helps!
Regards,
Kostadin Kostov