title: Proper way to execute a large SQL query in vb.net
body: <p>I have a SQL query that I used my vb.net application to run it, but i have a problem when It exceeds to its command timeout property. I set it to 300, any tips or suggestions?</p>
  
  <p>here is the snippet of my code in vb.net</p>
  
  <pre><code>  .ExecuteQuery("exec spCentrIX_PracticeSet '" &amp; oCompany &amp; "','" &amp; .SecDatabaseName &amp; "'", sDataSet)
    Application.DoEvents()
    .ExecuteQuery("exec spCentrIX_PracticeSet '" &amp; oCompany &amp; "','" &amp; .SetDatabaseName &amp; "'", sDataSet)
    Application.DoEvents()
    .ExecuteQuery("exec spCentrIX_PracticeSet '" &amp; oCompany &amp; "','" &amp; .TranDatabaseName &amp; "'", sDataSet)
    Application.DoEvents()
  </code></pre>
  
  <p>same script that run three times. this script gets all the data from the 3 databases which runs okie. however, when it is running...it exceeds the connection timeout of my code.</p>