C#中事务

dbconn的定义略try{    dbconn.Open();    foreach(GridViewRow row in GridView.Rows)    {        string userID = row.Cells[0].Text;        string userName = row.Cells[1].Text;        string sqlStr = "INSERT INTO user(userid, userName) VALUES('" + userID + "', '" + userName + "');        DbCommand dbCommand = db.GetSqlStringCommand(sqlStr);        db.ExecuteNonQuery(dbCommand);    }    dbtran.Commit();}catch{        dbtran.Rollback();}finally{    dbconn.Close();}