Stored procedure receives multiple parameter problems Master invited

marszdn

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

mgs_pexp

Can you be more detailed upstairs ~~~

mgs_pexp

Let's put it this way: I combined the selected image IDs into a string in the background of the page, separated by commas, such as: "1,2,3,4,6,7,8,"
This is passed to the stored procedure. The stored procedure splits the string of IDs, and then the name field is "tested" based on these IDs.
How to write specific stored procedures

 I am a rookie! !! !! !! Heroes don't just talk about ideas and actual code! !! !!

mgs_pexp

Continue to wait for the master

echg2002

To update uncertain data content with stored procedures, it is best to use DataAdpater + DataSet

echg2002

SqlDataAdapter catDA = new SqlDataAdapter ("SELECT CategoryID, CategoryName FROM Categories", nwindConn);
catDA.UpdateCommand = new SqlCommand ("UPDATE Categories SET CategoryName = @CategoryName" +
                                     "WHERE CategoryID = @CategoryID", nwindConn);

catDA.UpdateCommand.Parameters.Add ("@ CategoryName", SqlDbType.NVarChar, 15, "CategoryName");

SqlParameter workParm = catDA.UpdateCommand.Parameters.Add ("@ CategoryID", SqlDbType.Int);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;

DataSet catDS = new DataSet ();
catDA.Fill (catDS, "Categories");

DataRow cRow = catDS.Tables ["Categories"]. Rows [0];
cRow ["CategoryName"] = "New Category"; // Here changed one line of data, you can modify multiple lines by loop


catDA.Update (catDS);

ps: copied from above
ms-help: //MS.MSDNQTR.2003FEB.2052/cpguide/html/cpconupdatingdatabasewithdataadapterdataset.htm

mgs_pexp

This method is too good. Is there any other way

踩死过河马

----
Let's put it this way: I combined the selected image IDs into a string in the background of the page, separated by commas, such as: "1,2,3,4,6,7,8,"
This is passed to the stored procedure. The stored procedure splits the string of IDs, and then the name field is "tested" based on these IDs.

.......

The brother upstairs has given:

wwhhoon

 CREATE PROCEDURE Test
    @idString NVARCHAR (1000) // If its value is 1,2,3,4,6,7,8
AS
    DECLARE @sql NVARCHAR (2000)

    SET @sql = "UPDATE Images SET [Name] = 'Test' WHERE (ID IN ('" + @idStrings + "')"

    exec @sql


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

mgs_pexp

This is not easy to make ~~~~ There is a problem.
Which big brother should check it and change the error 1! !!

pupupu01

Modify the stored procedure. Let the parameter received by the stored procedure be a string separated by ",". Then go to the stored procedure for processing.

For example: "1,2,3,4,5,6" Then you choose ten, which is 10 strings with ID numbers separated by ",".

There is no need to think about executing it a few times.