我往数据库里写数据的程序是这么写的：
using (SqlConnection Conn = new SqlConnection(ConnString))
{
Conn.Open();
using (SqlTransaction Tran = Conn.BeginTransaction())
{
try
{
//SQL for Insert
}
catch
{
Tran.Rollback();
}
finally
{
Conn.Close();
Conn.Dispose();
}
}
}