title: How to Refresh datagridview continously after Updating
body: <p>I am using This code for Updating my datagrid view after the data is updated in access database.The Data is updated for every second i kept this code in a loop in a background but when i am starting the background a big X is being displayed.</p>
  
  <pre><code>  try
          {
              OleDbDataAdapter dAdapter;
              OleDbCommandBuilder cBuilder;
              DataTable dTable;
              BindingSource bSource = new BindingSource();
          dAdapter = new OleDbDataAdapter("Select * from data", cls_rt.con);
  
          //create a command builder
          cBuilder = new OleDbCommandBuilder(dAdapter);
  
          //create a DataTable to hold the query results
          dTable = new DataTable();
  
          //fill the DataTable
          dAdapter.Fill(dTable);
  
  
          //BindingSource to sync DataTable and DataGridView
          bSource = new BindingSource();
  
          //set the BindingSource DataSource
          bSource.DataSource = dTable;
  
          DataGridView.DataSource = dTable;
          }
          catch (Exception)
          {
  
          }
  </code></pre>
  
  <p>Then I used this code </p>
  
  <pre><code>        try
          {
              this.dataTableAdapter.Fill(this.rTDataSet.data);
          }
  </code></pre>
  
  <p>and kept this in loop </p>
  
  <pre><code>        dataDataGridView.Update();
  </code></pre>
  
  <p>then</p>
  
  <pre><code>        dataDataGridView.Refresh();
  </code></pre>
  
  <p>then</p>
  
  <pre><code>        dataDataGridView.RefreshEdit();
  </code></pre>
  
  <p>but it dint work for me</p>
  
  <p>I want my datagridview to update for every second and one more thing when it gets update i dont want the whole gridview to update i just want the particular cell to be update.</p>
  
  <p>Their would be a great appreciation if someone could help me.</p>
  
  <p>Thanks In Advance.</p>