62,047
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=XXX;Integrated Security=True");
conn.Open();
SqlTransaction myTrans = conn.BeginTransaction();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.Transaction = myTrans;
try
{
for (int i = 0; i < 100; i++)
{
comm.CommandText = "INSERT INTO Table1 (card, password)VALUES('CARD','PASSWORD')";
comm.ExecuteNonQuery();
}
myTrans.Commit();
}
catch (SqlException ex)
{
myTrans.Rollback();
}
conn.Close();
}
sql="insert into cardinfo(card,password)values('"+card1+"','"+password1+"');insert into cardinfo(card,password)values('"+card2+"','"+password2+"');......"
/*
批量执行sql语句
suyiming
2008年4月14日9:49:46
*/
CREATE proc UP_UpdateSql
@updatesql ntext
as
begin
EXECUTE sp_executesql @updatesql
end
GO