listbox and sql stored procedure

From: John (stomss2003_at_yahoo.com)
Date: 06/30/04


Date: Wed, 30 Jun 2004 16:32:06 +0100

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



Relevant Pages

  • 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.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)
  • Re: getting single selected value from listbox
    ... The combo is bound to a stored procedure but I only wish to obtain the value ... "Jeff Boyce" wrote: ... A listbox with, say, 4 fields displayed can have 17 fields, with a width ... I am not allowing multiple value selection so should ...
    (microsoft.public.access.forms)
  • 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: Parameters
    ... ALTER FUNCTION dbo.My_Function2(@order nvarchar (10), ... In the listbox simple selection mode i used the following code: ... > generated sql and drop the stored procedure, or you can make the stored ... > It looks like your performing a query against a stored procedure. ...
    (microsoft.public.dotnet.framework.aspnet)