c#中循环调用存储过程插入数据,只能插入最后一条

来源:百度知道 编辑:UC知道 时间:2024/05/06 12:02:24
JScript.Alert(count.ToString());
//将两个数组数据存入数据库
for (int j = 0; j < count; j++)
{
JScript.Alert(intid[j].ToString());
JScript.Alert(result[j]);
jsjt.jtid = intid[j];
jsjt.jtming = result[j];
jsjt.storeProcedure = "insert_one";
}
这个是存储过程:
CREATE PROCEDURE insert_one
(
@id int,
@jsid int,
@jtming varchar(50),
@jtid int
)
AS

INSERT INTO jsjt
(
jsid,
jtming,
jtid
)

VALUES
(
@jsid,
@jtming,
@jtid
)
GO

for (int j = 0; j < count; j++)
{
JScript.Alert(intid[j].ToString());
JScript.Alert(result[j]);
jsjt.jtid = intid[j];
jsjt.jtming = result[j];
jsjt.storeProcedure = "insert_one";
//这里少了一句提交
jsjt.executeProcedure();
}