Can someone please help out with this particular problem, I'm trying set up 2 datagridviews on a page. Both access the same tables through the same stored procedure. My project contains a dataset which has the appropriate stored procedure in a tableadapter.
The idea is that 2 datagridviews will provide results for 2 different searches. The problme is that they can't look at the same tableadapter, this will provide identical results in both datagridviews.
So far the only thing I can think of is to programatically create a new instance of the tableadapter object. The problem there is that I can't point a bindingsource to this tableadapter when used in the designer (it will only let me point to the defined tableadapters in the dataset)
Does anyone have any ideas?