update combobox

abdelwaheb ammar

hi, I have a problem with combobox. I create a combobox in form1 this combobox display a list from the database. in addition i create another form2 makes a update on the table but the combo box list does not do this update. Can someone help me to solve this?

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priyaranjan K S11y ago
Hi,
If you found this useful Please Accept this as Answer .

Thanks,
Priyan
abdelwaheb ammar11y ago
thank you sir this is a solution :)
Priyaranjan K S11y ago
Hi ,

You may do something like this :

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
Form2 frm = new Form2(this);
frm.Show();
}
}

public partial class Form2 : Form
{
Form _frm;
public Form2(Form frm)
{
_frm=frm;
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{

//Update the SQL Data Base
//Get the Database table and use it as the data source for populating the form 1 combo box

Form1 objMain = (Form1)_frm ;
objMain.comboBox1.DataSource = UpdatedSQLDataSource;
}
}

For More reference : https://social.msdn.microsoft.com/Forums/en-US/46408a73-045f-4d61-a43c-c3e2aa99b049/change-textbox-value-from-another-form?forum=csharplanguage

Thanks,
Priyan

If you found this useful Please Accept this as Answer
abdelwaheb ammar11y ago
exactly what the problem is her. but how to do it?
Priyaranjan K S11y ago
Ok, What I outlined earlier in one of my replies was the solution to this problem . So is the main issue "You are not able to Re-Populate the combo box in Form 1 from Form 2 after updating the Data base " ?
abdelwaheb ammar11y ago
yes this is the problem and your understand is correct
Priyaranjan K S11y ago
My understanding of your problem is You have a combo box in form 1 that shows the data from a table in the DB . Now you update the DB from form 2 . But the latest updated data is not shown in the combo box present in Form 1 . Please correct me if I am wrong in understanding your problem .

Thanks,
Priyan
abdelwaheb ammar11y ago
so this is the heart of the problem.how can i populate the combobox and i make the update in form2 and not in form1(where exist the combobox)?
Priyaranjan K S11y ago
Say in Form 2 you are probably saving the data to the database during some button click . In the click event you might have some code to establish the connection and update the DB . In the same click event once you have completed the DB update write the code to populate the Combo Box (This would be ideally the same code you would have written in Form 1)

Thanks,
Priyan

If you found this useful Please mark this as Answer
abdelwaheb ammar11y ago
sorry i can't understand you when you say "the next statement should be to populate the combo box again from the DB" can you give an example or tutoriel or any thing to understand you ?
Priyaranjan K S11y ago
Hi,

Is your problem that the the update made from Form 2 is not becoming visible in the Combo box in Form 1 ?

This is probably because :
On form1 Load you are populating the combo box with values from the DB . In form 2 you are updating the data base . But the combox is not binded with the latest db data . So once you update the database from form2 the next statement should be to populate the combo box again from the DB . This logic should be written in Form 2 itself .

Thanks,
Priyan

If you found this useful Please mark this as Answer