1    public static SqlTransaction StartTransaction()
2    {
3        SqlTransaction trans;
4        con = new SqlConnection(ConnectionString);
5        con.Open();
6        trans = con.BeginTransaction();
7        return trans;
8    }