title: Refreshing dataGridView items on adding or deleting entry in database?
body: <p>i am adding , deleting and updating data to database in Winforms. i have gridview on all add,delete and update forms.
  After deleting records on clicking "delete" button  deleted record should removed instantly from dataGridView.</p>
  
  <p>////Please note that DATABIND is giving error i.e. using or assembly reference missing.</p>
  
  <p>Code Behind:</p>
  
  <pre><code>    private void btnDelete_Click(object sender, EventArgs e)
      {
  
          if (txtIDD.Text == "")
          {
              MessageBox.Show("Please fill ID no. of record to Delete", "Important Message");
  
          }
          else
          {
              try
              {
                  OleDbCommand Cmd = new OleDbCommand();
                  Cmd.Connection = conn;
                  conn.Open();
                  Cmd.CommandText = "DELETE FROM AddressBook WHERE ID="+txtIDD.Text;
                  Cmd.CommandType = CommandType.Text;
                  Cmd.ExecuteNonQuery();
                  Cmd.Connection.Close();
                  conn.Close();
                  dataGridView3.Update();
                  MessageBox.Show("Delete Succesfull");
              }
              catch (System.Exception err)
              {
                    dataGridView3.DataSource = dt;
                    dataGridView3.DataBind();
                    dataGridView3.Update();
  
                  this.label27.Visible = true;
                  this.label27.Text = err.Message.ToString();
              }
          }
  
      }
  </code></pre>