using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["textconnstring"].ToString())) { if (conn.State == ConnectionState.Closed) conn.Open(); SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadUncommitted); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlStr1; cmd.Transaction = trans; cmd.ExecuteNonQuery(); cmd.CommandText = sqlStr2; cmd.Transaction = trans; cmd.ExecuteNonQuery(); using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["textconnstring"].ToString())) { SqlCommand cmd1 = new SqlCommand(sqlStr, conn1); SqlDataAdapter sda = new SqlDataAdapter(cmd1); DataSet ds =new DataSet(); sda.Fill(ds); } trans.Commit(); }catch(SqlException ex) { trans.Rollback(); Console.WriteLine(ex.Message); } } 其中sqlStr1和 sqlStr2為插入語句，sqlStr為查詢語句。conn和conn2是兩個不同的連接，但是在執行時到了“sda.Fill(ds)”時程序會卡住，然后就是超時錯誤了，不知是什么原因？