使用事务处理

 StringBuilder stringBuilder = new StringBuilder();
        SqlConnection conn1 = iConnection();
        SqlCommand comm1 = conn1.CreateCommand();
        SqlTransaction tram1 = conn1.BeginTransaction();    //定义一个事务

        comm1.CommandType = CommandType.Text;
        comm1.CommandText = "select * from matchs_info where matchid=" + matchid;
        comm1.Transaction = tram1;
        SqlDataAdapter da1 = new SqlDataAdapter(comm1);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1);
        DataTable dt1=ds1.Tables[0];
        tram1.Commit();                                                                //开始一个事务

        try
        {
            for (int i1 = 0; i1 < dt1.Columns.Count; i1++)
            {
                if (i1 > 0)
                {
                    stringBuilder.Append("|");
                }
                stringBuilder.Append(dt1.Rows[0][i1].ToString());

            }
        }
        catch
        {
            tram1.Rollback();   //回滚一个事务
        }
        finally
        {
            conn1.Close();
        }
        string a = stringBuilder.ToString();
    
        return a;