所有分求助..批量删除存储过程问题
程序部分:

string Oid = CleanString.htmlInputText(Request.Form[ "idList "].ToString().Trim());

SqlCommand cmdd = new SqlCommand( "Del ",conn);
cmdd.CommandType = CommandType.StoredProcedure;
cmdd.Parameters.Add(new SqlParameter( "@Userid ",Userid));
cmdd.Parameters.Add(new SqlParameter( "@Oid ",Oid));
cmdd.Parameters.Add(new SqlParameter( "@Fen ",Fen));
cmdd.ExecuteNonQuery();
conn.Close();

存储过程:

CREATE PROCEDURE Del
(
@Userid int,
@Oid varchar(20)
)
AS
DECLARE @errorFound tinyint
Select @errorFound = 0

BEGIN TRANSACTION

delete OfferList where Userid=@Userid and Oid in (@Oid)

IF @@ERROR > 0 SET @errorFound = 1
IF (@@ERROR > 0) OR (@errorFound > 0)
ROLLBACK
ELSE
COMMIT
GO

运行错误提示:

将 varchar 值 '141,142,147,149 ' 转换为数据类型为 int 的列时发生语法错误

所有分都加上了,请大哥大姐们帮帮忙吧......

[解决办法]
实在不行 建议用SQL语句删除。。


[解决办法]
Oid 里面因该是多个 序号. 不是LZ这么做的 你应该先用STRING拆分好 ID 生成一个数组 然后执行多次删除. 一个循环处理 直到数组里的ID 都执行过
[解决办法]
上面写错了，少了一个 execute

CREATE PROCEDURE Del
(
@Userid int,
@Oid varchar(200)
)
AS
DECLARE @ERRORFOUND tinyint
DECLARE @sqlstring nVARCHAR(200)
SET @ERRORFOUND = 0

BEGIN TRANSACTION

SET @sqlstring = N 'delete OfferList where Userid=@Userid and Oid in ( ' + @OID + ') '
execute sp_executesql @sqlstring

SET @errorFound = @@ERROR
IF (@errorFound > 0)
SET @errorFound = 1
ROLLBACK
ELSE
COMMIT
GO