Member Avatar for sbanks_charles

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?

Thanks
Charles

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Chris147
Member Avatar for Chris147

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).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.