listbox and sql stored procedure

Hi,
First of all sorry for my not perfect english.

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 delete 7 rolls in my table. Thats simple,
but what if user select 3 or 30 items in listbox? The problem is that I dont
know the number of the parameters, and how to pass them. can I use array
or is there some different solution?

Of course I can take the collection of items and for every item, I can call
stored procedure, but this is no good in performance reason.
Please help meAre you asking how to pass variable number of values to a stored procedure?
If it is the question, merge all values into one string and parse it in the
stored procedure.

Eliyahu

"John" <stomss2003@.yahoo.com> wrote in message
news:uDp5mcrXEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> First of all sorry for my not perfect english.
> 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 delete 7 rolls in my table. Thats simple,
> but what if user select 3 or 30 items in listbox? The problem is that I
dont
> know the number of the parameters, and how to pass them. can I use array
> or is there some different solution?
> Of course I can take the collection of items and for every item, I can
call
> stored procedure, but this is no good in performance reason.
> Please help me
Deep Wrote:
Concatenate the values in a string delimited with some other string like "|" e.g.1|2|3. Pass this string to a stored procedure. Use charat function to extract individual numbers and the fire delete statements.

"Eliyahu Goldin" wrote:

> Are you asking how to pass variable number of values to a stored procedure?
> If it is the question, merge all values into one string and parse it in the
> stored procedure.
> Eliyahu
> "John" <stomss2003@.yahoo.com> wrote in message
> news:uDp5mcrXEHA.3016@.tk2msftngp13.phx.gbl...
> > Hi,
> > First of all sorry for my not perfect english.
> > 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 delete 7 rolls in my table. Thats simple,
> > but what if user select 3 or 30 items in listbox? The problem is that I
> dont
> > know the number of the parameters, and how to pass them. can I use array
> > or is there some different solution?
> > Of course I can take the collection of items and for every item, I can
> call
> > stored procedure, but this is no good in performance reason.
> > Please help me
>