110,561
社区成员
发帖
与我相关
我的任务
分享
public int Delete(string ProductId)
{
//cmdText = "delete from Product where ProductId in (" + ProductId + ")";
//res = sqlhelper.ExecuteNonQuery(cmdText, CommandType.Text);
//return res;
string TempString = "("+ProductId+")";
cmdText = "delete from Product where ProductId in @TempString";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@TempString",TempString)
};
res = sqlhelper.ExecuteNonQuery(cmdText, CommandType.Text);
return res;
}
CREATE FUNCTION [dbo].[f_split](@c varchar(2000),@split varchar(2))
returns @t TABLE(col varchar(20))
AS
begin
while(charindex(@split,@c)<>0)
begin
INSERT @t(col) VALUES (substring(@c,1,charindex(@split,@c)-1))
SET @c = stuff(@c,1,charindex(@split,@c),'')
end
INSERT @t(col) VALUES (@c)
RETURN
end
GO
string TempString = "("+ProductId+")";
cmdText = "delete from Product where ProductId in (select * from dbo.f_split(@TempString,’,'))";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@TempString",TempString)
};