Dear developers,

I am coding a very small project for my study. I want to refresh form1 after form2 is closed. For example, I open form1 and click one button to open form2 and in form2 I insert data to the database (ex : tblItem). In addition, combobox in form1 retrieves data from the database (tblItem) too when formload (form1 load). So, after inserting data from form2 and when I close the form2, I want the comboxbox in form1 refresh to retrieve the last update of tblItem data.

Here is my code to open form2

form2 frmitem = new form2();
frmitem.ShowDialog();

Please advise, thanks.

Visoth

I don't see the problem. Just put the code to update the combo box after the ShowDialog() line.

Ideally this would be the same code that loaded the combo box in the first place, so extract that code into a method and call it in both places.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?

Here is the code that I load it to combobox on form1

public void cboItem_load()
{
try
{
clsConnection.dbcnn.Open();
string str = @"Select iid, name_en From tbl_item";
OleDbDataAdapter dtadaptor = new OleDbDataAdapter(str, clsConnection.dbcnn);
DataSet dtset = new DataSet();
dtadaptor.Fill(dtset, "tbl_item");
this.cbo_itemname.DataSource = dtset;
this.cbo_itemname.DisplayMember = "tbl_item.name_en";
this.cbo_itemname.ValueMember = "tbl_item.iID";
this.cbo_itemname.SelectedIndex = -1;
clsConnection.dbcnn.Close();
}
catch (Exception Er)
{
MessageBox.Show(Er.Message, "Exception");
}
}

When I close form2 what should I do to make the combobox on form1 refresh?


***** I am a beginner in C Sharp, so I hope to learn from you all.

Thanks,

Simply call the method:

You are aware that the ShowDialog() method waits until the form closes aren't you?

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?

Sorry bro, I even do not know how to call a sub procedure. Would you mind to write me down a code?

Many thanks,

Visoth

err, I did.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?