I have a form which displays related data from three different tables. There is a foreign key between the master table and the two related. Currently I have three stored procedures to return the data based of the return key value from a search. Because I am using DataAdapters to select and modified the recordsets I need three sepearte datasets. This works great, but I'm sure adds a lot of overhead. In VB 2008 with SQL 2008, is there a way I could use only one stored procedure to accomplish this?


Given that you're using VB 2008 you could use a TableAdapter, rather than three DataAdapters, then - using the TableAdapter - create a Query that selects all of the necessary info and use a single procedure to filter the Query. This may be possible with DataAdapters too (I honestly don't know - I always use TableAdapters).