只要加上带注释的关于事务的三行,就提示无效操作protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa;");
SqlTransaction tran = con.BeginTransaction();//定义一个事务
try
{
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from authors", con);
DataSet ds = new DataSet();
adp.Fill(ds, "b");
GridView1.DataSource = ds.Tables["b"];
GridView1.DataBind();
tran.Commit();//提交
}
catch
{
tran.Rollback();//回滚
}
finally
{
con.Close();
}
}
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa;");
SqlTransaction tran = con.BeginTransaction();//定义一个事务
try
{
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from authors", con);
DataSet ds = new DataSet();
adp.Fill(ds, "b");
GridView1.DataSource = ds.Tables["b"];
GridView1.DataBind();
tran.Commit();//提交
}
catch
{
tran.Rollback();//回滚
}
finally
{
con.Close();
}
}
tran.Commit();//提交
这个是不是多余了啊。你查询而已,提交啥?
{
conn.Open();
SqlCommand comm = conn.CreateCommand();
SqlTransaction trans = conn.BeginTransaction();
comm.Transaction = trans;
try
{
...
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
}
conn.Close();
这样使用事务处理