I have a typed dataset with a customers table. here is some code for reference

Private custTA As New MyDS.CustomersTableAdapter
cbxCustomers.DataSource = custTA.GetData()
cbxCustomers.DisplayMember = "CustName"
cbxCustomers.ValueMember = "CustID"

I insert a new customer by calling a stored procedure.
custTA.InsertCustomer( "Name","Address")

Whats the best way to refresh the combobox which is bound to the table?

Dear sdoc,

Code:

custTa.Clear();

custTA.InsertCustomer( "Name","Address")
custTa.Refresh();

HTH,

Suprotim Agarwal

there is not Refresh method available on the tableadapter.

Dear sdoc,

That was a typo.

The refresh was for the combo. Try the following code :

cbxCustomers.Clear();

cbxCustomers.DataSource = custTA.GetData();
cbxCustomers.DisplayMember = "CustName";
cbxCustomers.ValueMember = "CustID";

cbxCustomers.Refresh();

HTH,

Suprotim