Stored procedure receives multiple parameter problems Master invited

mgs_pexp

I used DataList to make a list of pictures. I want to add the selected pictures to the album.
for (int i = 0; i <DataList1.Items.Count; i ++) // Cycle the collection of DataList1
{
    if (xx.checked) // If the picture is selected
      {
         int id = e.Item.FindControl ("label1") // Remove the ID of this image
         int classid = 1 // album id
         ................. / Execute the stored procedure
      }
}

This is my implementation method. This loop judges which picture is selected. If selected, the picture id and album ID are passed to the stored procedure and executed once. If 10 are selected, this loop executes the stored procedure 10 times, so that 10 pictures are modified.
What can I do to execute the stored procedure once to modify these 10 pieces of data. What should be written in the stored procedure

Heroes had better post some code. My little rookie

mgs_pexp

I wonder if the stored procedure can receive a set of data? That is, I took out the selected IDs in the previous paragraph and passed them to the stored procedure once, so that I did not need to execute the stored procedure 10 times.

头不晕

With a parameter
Separate items with special characters
Split each item in the storage process

shenmue024

Stored procedures can receive multiple parameters, but the number of parameters is fixed.

There is another way.

Pass a string. It is then split during the stored procedure. Then generate sql
Then exec this sql.

苹果小刀

Split string!

shenmue024

Of course, the simple way is to generate SQL in the program instead of using stored procedures.

釉之前

create or replace type mytable as table of varchar2 (1000);

Call mytable

wwhhoon

CREATE PROCEDURE Test
    @idString NVARCHAR (1000)
AS
    DECLARE @sql NVARCHAR (2000)

    SET @sql = "UPDATE Images SET album = 1 WHERE (ImageID IN ('" + @idStrings + "')"

    exec @sql


@idStrings is a combination of the above from your code in the form:
    imgeid1, imageid2, imageid3

looser_01

If the number of incoming strings is large and the combined length of the combined string exceeds 4000, consider using Xml

marszdn

Upstairs ok