Multiple Select listbox and sql stored procedure -Help needed

Hi,
I've got listbox in my .aspx page where the users can make multiple
selection.
So, Users can select 7 items in listbox, I have to take value from
items and
pass it to stored procedure to extract a dataset back.

1.What should i do while passing the multiple selected values
2.Can i use 'in' clause in SQL procedure like
eg:Select a.xxx from a where a.yyy in @y
@y is the multiple selected values from listbox.
3.How to concatenate and send to SQL Procedure.


Please help me

.

Relevant Pages

  • Re: Multiple Select listbox and sql stored procedure -Help needed
    ... I've got listbox in my .aspx page where the users can make multiple ... selection. ... you can pass it into a stored procedure as a parameter. ...
    (microsoft.public.dotnet.languages.csharp)
  • Multiple Select listbox and sql stored procedure -Help needed
    ... I've got listbox in my .aspx page where the users can make multiple ... selection. ... 3.How to concatenate and send to SQL Procedure. ...
    (microsoft.public.dotnet.languages.vb)
  • databounded listbox with datagrid results complete description
    ... i have a databound listbox id "listboxcity" that has a multilple ... SqlDataReader citydr; ... till now it is working for single value selection and its succsseful ... Now how to make changes in it for multiple ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: list box
    ... The value of the listbox is stored in the Control Source's field. ... of the listbox is from the Bound Column of the selected row. ... you shouldn't store multiple values in a field. ... fields, perhaps several Yes/No fields, one for each possible selection. ...
    (microsoft.public.access.forms)
  • Re: Last Selection from MultiSelect Listbox
    ... What you can do is track the listbox selection in an array by modifying an array every time the listbox is changed. ... Dim idx As Integer, i As Integer ...
    (microsoft.public.excel.programming)