向数据库插入多条数据时,没有插入数据库,也不提示错误?请大虾帮帮忙。protected void btnSave_Click(object sender, EventArgs e)
{
int j =Convert.ToInt16(Label1.Text.ToString());
MySqlConnection myConnection = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlPR"].ConnectionString);
myConnection.Open();
MySqlTransaction myTrans=myConnection.BeginTransaction;
MySqlCommand myCommand=new MySqlCommand();
myCommand.Transaction=myTrans;
try{
for (int i = 1; i <= j; i++) //这儿做循环插入
{
myCommand.CommandText = "Insert INTO pr_form_detail(prno) values('000011')";
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
}
catch(Exception)
{
myTrans.Rollback();
}
finally{
myConnection.Close();
}
}
{
int j =Convert.ToInt16(Label1.Text.ToString());
MySqlConnection myConnection = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlPR"].ConnectionString);
myConnection.Open();
MySqlTransaction myTrans=myConnection.BeginTransaction;
MySqlCommand myCommand=new MySqlCommand();
myCommand.Transaction=myTrans;
try{
for (int i = 1; i <= j; i++) //这儿做循环插入
{
myCommand.CommandText = "Insert INTO pr_form_detail(prno) values('000011')";
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
}
catch(Exception)
{
myTrans.Rollback();
}
finally{
myConnection.Close();
}
}
我把catch中的语句屏蔽了,还是不行,有没有其他方法?
catch(Exception)
{
// myTrans.Rollback();
}
LZ你调试的时候还不如把错误调出来呢
catch(Exception ex)
{
myTrans.Rollback();
throw ex;//看看会不会报错
}
j是否大于1