namespace Day04_001事务
{
class Program
{
static void Main(string[] args)
{
string str = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
string sql="insert into grade (gradename) values ('S2226')";
using (SqlConnection conn=new SqlConnection(str))
{
SqlCommand cmd=new SqlCommand(sql,conn);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran;
try
{
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
Console.WriteLine("add ok");
}
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
}
}
Console.ReadKey();
}
}
}
namespace using释放资源
{
class Program
{
static void Main(string[] args)
{
string sql="select * from student";
using