how to refresh the dataset

Violeta Popa

Hello :) I have a combobox which is filled with a fillbytoolstrip but before filling the cb i want to refresh the dataset, how can i do that?

private void adaugaContract_Load(object sender, EventArgs e)

{

// TODO: This line of code loads data into the 'asigurariDataSet.client' table. You can move, or remove it, as needed.

this.clientTableAdapter.Fill(this.asigurariDataSet.client);

fillBy2ToolStripButton_Click(sender, e);

}

private void fillBy2ToolStripButton_Click(object sender, EventArgs e)

{

try

{

this.clientTableAdapter.FillBy2(this.asigurariDataSet.client);

}

catch (System.Exception ex)

{

System.Windows.Forms.MessageBox.Show(ex.Message);

}

7 Replies

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

Vulpes13y ago
I've never heard of the FillByToolStrip before - and googling it revealed very little - but it appears to be filling a DataTable in the DataSet via a TableAdapter i.e. directly from the database and I imagine you must then be binding the ComboBox to the Name column of this table.

Assuming you're also binding the DGV to this table, then you'll need to call the DataAdapter's Update method to write the changes to the DataTable back to the database.

You'll then need to clear the DataTable, refill it using the TableAdapter via the FillByToolStrip and rebind the Name column to the ComboBox.

This sounds like it may be slow procedure but I'd try it and see.
Violeta Popa13y ago
i use neither list, nor array..i just use the fillbytool for filling the combobox :-?
Vulpes13y ago
Well, you'd need to detect when a new record is added on the form containing the DGV and then communicate it to Form2.

How are you passing the client names to Form2 initially, using a List or array perhaps?
Violeta Popa13y ago
i'm sorry for asking so many questions..but how can i check on form2 if a new record is added in the dgv?
Vulpes13y ago
The code I suggested is to refresh the DataSet following changes made to the database itself so it's nothing to do with the problem which you've just described which is to do with inter-form communication.

What you need to do is to refresh the combobox on form2 when a new record is added to the DGV on form1 so I'd have thought that whatever code you used to fill the combobox in the first place will need to be called again after the combobox has been cleared of its previous items.
Violeta Popa13y ago
It doesn't work :( I'll try to explain, maybe this isn't the real problem.
I have a form, form1 which contains a datagridview. I'm adding a new record in the dgv with information about a client. In form2, i have a combobox whose items are the clients name from the dgv. If i add a new client in form 1, when i go to form 2, the combobox should contain this new client, but it doesn't. It shows the new client only if i restart my application :(
Vulpes13y ago
To refresh the DataSet, just call the TableAdapter's Fill method again on that DataSet.

However, before you do that I'd call the DataSet's Clear method to make sure all existing data is removed.,