title: Update and select in one query
body: <p>I found similar questions with correct answers. But they're a bit complicated for me.  I just want a simple basic statement.</p>
  
  <p>I have:</p>
  
  <pre><code>string sql = "UPDATE tblPopUp 
                   SET PopUp = 'False' 
                 WHERE DisplayNo = 1"
  </code></pre>
  
  <p>...and:</p>
  
  <pre><code>string sql1 = "SELECT Period  
                   FROM tblPopUp 
                  WHERE DisplayNo = 1"
  </code></pre>
  
  <p>How can I combine them?</p>