how to create a typed dataset with multiple tables?

  • Thread starter Thread starter fredd00
  • Start date Start date
F

fredd00

Hi

I have a stored proc that returns
2 record set (tables)

i have 1 select that returns the error id and error message
and 1 select for the data

when i drop the stored procedure on the designer of the DataSet I only
get a table for the first record set (table)

i would like my typed data set to fill both tables on the fill method

any help

thanks

i'm using vs2005 and mssql 2000
 
Can you post the code that you're using to fill the dataset?
Or do you just mean that you want it to show both tables
in the DataSet Designer?


Robin S.
 
Check that an additional table isn't being created. I'm guessing that one
is - and if it is, then you can simply specify the TableMappings property of
the adapter to correctly point to both tables and you should be good to go.
Since the designer 'sees' the first table, I'm guessing the names/columns
match so one is getting filled, the other is being stuck in another table.
Specifying the tablemappings should fix it.
 
I would like to see both tables in the designer
Can you post the code that you're using to fill the dataset?
Or do you just mean that you want it to show both tables
in the DataSet Designer?


Robin S.
Click to expand...
 
I've never tried dropping a Stored Procedure on the
DataSet Designer before. What does your Stored
Procedure look like?

Robin S.
----------------------------------------
 
Back
Top