Updating Database and DataGridView on single button click

Question

I am adding values to a local database on a button click.

This is working fine, but I want to see my changes as soon as click the button.

In order to get the new information that I just created with the button click I have to stop debugging and re-run the program.

Is there an way to update the database and my DataGridView without having to stop and restart the program?

private void addCoachBtn_Click(object sender, EventArgs e)
{
  string ConnectionString = (@"Data Source=|DataDirectory|c:\BaseballDB.sdf");

  try
  {

    SqlCeConnection conn = new SqlCeConnection(ConnectionString);
    conn.Open();

    SqlCeCommand cmd = conn.CreateCommand();
    cmd.CommandText = 
      "INSERT INTO Coach " +
      "(FirstName, LastName, Team, Age) " +
      "VALUES " +
      "('" + FirstNametxt.Text + "', '" + LastNametxt.Text + "',  '" + Teamtxt.Text + "','" + Agetxt.Text + "')";
    cmd.ExecuteNonQuery();

    conn.Close();
    this.Close();
  }
  catch (Exception er)
  {
    MessageBox.Show("Not Connected");
    //MainGUI mg = new MainGUI();
    //mg.outputText(er.ToString());
    Console.WriteLine(er);
    MessageBox.Show(er.Message.ToString());
  }

}

To output the error message to MainGUI, delete the line MainGUI mg = new MainGUI(); and replace mg.outputText(er.ToString()); with this.outputText(er.ToString()); — user153923
– user153923, Commented Dec 2, 2013 at 21:15

Mike Perrenoud · Accepted Answer · 2013-12-02 21:09:15Z

1

Yes, the same code you used to bind the data grid on load, move it to a method and call it after the update is complete. That will re-bind the data grid.

answered Dec 2, 2013 at 21:09

Mike Perrenoud

68.1k32 gold badges167 silver badges238 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Updating Database and DataGridView on single button click

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related