title: Read Datatable and do a loop in rows async c#
body: <p>I'm trying to implement asynchronous methods in my program, and I want to read each row asynchronously from a datatable.
  I have the following situation:</p>
  <pre><code>   private void VerifyPermissions()
      {
          try
          {
              string constring = String.Format(&quot;server={0}; user id={1}; password={2}; database={3}; pooling=false&quot;, AcessoBancoDados.server, AcessoBancoDados.user, AcessoBancoDados.password, AcessoBancoDados.database);
  
              MySqlConnection con = new MySqlConnection();
              con.ConnectionString = constring;
              con.Open();
  
              var query = &quot;SELECT id FROM users&quot;;
  
              MySqlCommand cmd = new MySqlCommand(query, con);
              MySqlDataAdapter da = new MySqlDataAdapter(query, con);
  
              DataTable dt = new DataTable();
  
              da.Fill(dt);
              con.Close();
  
              foreach (DataRow item in dt.Rows)
              {
                 Messagebox.Show(item[&quot;id&quot;].ToString());
              }
      }
  </code></pre>
  <p>And the call method:</p>
  <pre><code>private void button1_Click(object sender, EventArgs e)
      {
         VerifyPermissions()
      }
  </code></pre>
  <p>Anyone can show me an async situation for this? Thanks.</p>