Well, this doesn't help too much. I have no idea what your queries are to fill these tables. Plus, I haven't really looked at the NorthWind database, so I'm not sure what the relationships are between those three tables. But since you're doing a DataSet1.Clear(), you *are* deleteing everything in your DataSet and so you *would* have to re-fill everything. Probably not the best way to structure this.
I've noticed that there is a Table level clear, DataSet1.Suppliers.Clear() ... perhaps this is what you need to use instead. I haven't actually tried this method, so I'm not sure how it works, but it sounds like what you need.
~~Bonnie
>I'm using Products, Categories, and Suppliers tables from NorthWind database.
>I want to retrieve the data of one product at a time.
>I'm not using Stored Procedures.
>I using two comboboxes cboSupplier & cboCategory to populate related data.
>
>When selecting a product, I run the following code
>DataSet1.clear
>DataAdapter1.Fill(DataSet1, "Categories")
>DataAdapter1.Fill(DataSet1, "Suppliers")
>DataAdapter1.Fill(DataSet1, "Products")
>
>If what I'm doing is correct, then everytime I select a different product I have to re-fill the suppliers & categories tables.
>
>How can avoid re-fill the two reference tables?
>
>