title: How to increase timeout of DataAdapter to 3 min?
body: <p>When i execute a query with the following method, i get a timeout. </p>
  
  <p>So my question is: how can i set the timeout to 180 seconds?</p>
  
  <p>I'm using the connection to fill the dataSet with the queryresult.</p>
  
  <pre><code> internal static DataSet executeQuery(string queryString)
   {
       // #connection
       DataSet dataSet = new DataSet();
       string connectionString = Connection.connectionStringSQL01NavProvider();
       OleDbConnection connection = new OleDbConnection(connectionString);
       OleDbDataAdapter adapter = new OleDbDataAdapter(queryString, connectionString);
  
       // Open the connection and fill the DataSet. 
       connection.Open();
       try
       {
           adapter.Fill(dataSet);
           DataTable dt = new DataTable();
           dt = dataSet.Tables[0];
           DataRow dr;
           try
           {
               dr = dt.Rows[0];
           }
           catch 
           {
  
           }
       }
       catch (Exception ex)
       {
           Console.WriteLine(ex.Message);
           System.Windows.Forms.MessageBox.Show("Error executeQuery().! " + ex.Message);
       }
  
       return dataSet;
   }
  </code></pre>