title: Inventry Form Not Updating itself after Save data C# Winform
body: <p>I want to include screen shots but stack overflow not letting me to do that.Hope I am clear to you in this way.In my application I want to autofill remaining text boxes if user name is already present in the SQLite database.Like in below code</p>
  
  <pre><code> private void cname_txt_KeyDown(object sender, KeyEventArgs e)
      {
          if (e.KeyCode == Keys.Enter)
          {
              SQLiteConnection sqliteCon = new SQLiteConnection(dbConnectionString);
              // open connection to database 
              try
              {
                  sqliteCon.Open();
                  string Query = "select * from OwnerDetails where Name='" + cname_txt.Text + "' ";
                  SQLiteCommand createCommand = new SQLiteCommand(Query, sqliteCon);
                  SQLiteDataReader dr = createCommand.ExecuteReader();
                  while (dr.Read())
                  {
                      string Name = dr.GetString(0);
                      string Agency = dr.GetString(1);
                      string CellNo = dr.GetString(2);
                      string Office = dr.GetString(3);
                      string Email = dr.GetString(4);
                      string Address = dr.GetString(5);
                      cname_txt.Text = Name;
                      cagency_txt.Text = Agency;
                      ccellno_txt.Text = CellNo;
                      coffice_txt.Text = Office;
                      cemail_txt.Text = Email;
                      caddress_txt.Text = Address;
  
                 }
                  sqliteCon.Close();
  
              }
              catch (Exception ex)
              {
                  MessageBox.Show(ex.Message);
              }
  </code></pre>
  
  <p>But my Application not updating itself from database recent values.
  I need to close application and then reopen it . Then it will show data in the autocomplete Name textbox.
  I have tried </p>
  
  <pre><code>this.refresh();
  this.dispose();
  this.hide();
  </code></pre>
  
  <p>almost all to main application but main application is not refreshing to new database values 
  I know I need to put any update query in the save button code but I am unable to do that.
  Your help will be appreciated</p>