Like the title says I want to create a SQL (2005) stored procedure where I say:
Select a, b, c from A Select b, c, d from B Select c, d, e from C
And so forth. The select statements are more complicated than that, and would be difficult to use a Join on. Shown below will be some code for setting up the data adapter.
Dim cmd as new SqlCommand() 'GetTables will be they hypothetical name of the stored procedure given above. cmd.commandText = "GetTables" cmd.commandType = Stored Procedure 'Any parameters needed Dim da as new DataAdapter(cmd) dim ds as new dataset() da.fill(ds)
Will ds be populated with the three tables I had in the stored procedure? Is that even possible? I did do some research using google, but nothing gave me an answer that I was confident enough to start coding myself, especially since SQL isn't my strong point. Thanks for any help!