C#数据回滚实例

private void save_db(){

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings[""].ToString());

SqlCommand comm = new SqlCommand();

conn.Open();

SqlTransaction rollbk2= conn.BeginTransaction();

comm.Connection=conn;

comm.Transaction=rollbk2;

try

{

for(i){

comm.CommandText="insert into ";

comm.ExecuteNonQuery();

}

rollbk2.Commit();

}

catch(Exception exp)

{

rollbk2.Rollback();

Response.Write("save_fail");

return;

}

finally

{

conn.Close();

}

Response.Write("save_ok");

}