执行下面代码会有超时异常？

Question

  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)”时程序会卡住，然后就是超时错误了，不知是什么原因？

Answer 1

你的把 conn1.Close() 放到 trans.Commit(); 的后面.

Answer 2

cmd1.CommandTimeout=0就好了