Stored Procedures for batch data deletion under. Net (using dynamic SQL)

SQL statement execution is normal

Public bool deleteuser (string userid)

{
String strsql = "delete from tb_users where userid in (" + userid + ")";
Return dbbase. executenonquery (false, strsql, null );

}

If a problem occurs during execution of the stored procedure, the string type cannot be converted to int32. The problem lies in the stored procedure:

Public static int deleteuser (string userid)
{
Int ret = 0;
String spname = "ty_deleteuser ";
Object [] para = new object [] {userid };
Ret = dataaccess. executenonquery (spname, false, para );
Return ret;

}

Incorrect Stored Procedure Syntax:

Create proc ty_deleteuser
(@ Userid INT)
As
Delete from tb_users where userid in (@ userid)

 

Correct Writing of stored procedures (dynamic SQL)

Create proc ty_deleteuser

(@ Userid nvarchar (250 ))
As

Exec ('delete from tb_users where userid in ('+ @ userid + ')')

 

The above is a cainiao-level problem. You don't need to read it if you know it. If you don't know it, you can read it. Thank you .....