title: C# live data stream from MySQL to DataGridView
body: <p>I've been struggling to find efficient solution to get live data from MySQL database to datagridview. In my database values are changing every second or even faster. I need to get live feed directly to my windows app. The only solution I could found is to use async, but then app get laggy when trying to move it arround or do other tasks. My attempt:</p>
  
  <pre><code>public async void refreshOutput()
      {
  
          while (true)
          {
              DataTable dbResults = Connect_ToDB.executeQuery("SELECT * FROM mysql.test_table;");
              dataGridView2.DataSource = dbResults;
              await Task.Delay(200);
          }
  
      }
  </code></pre>
  
  <p>Also I tried:</p>
  
  <pre><code>    private void button24_Click(object sender, EventArgs e)
      {
          DataTable data = Connect_ToDB.executeQuery("SELECT * FROM mysql.test_table;");
  
          BindingSource bSource = new BindingSource();
          bSource.DataSource = data;
  
          dataGridView2.DataSource = bSource;
  
  
      }
  </code></pre>
  
  <p>In any case i always need to push the button again to get new data. Is there a way to get it live without disturbing the application background processes? Thank you!</p>