how to create a typed dataset with multiple tables?

16 Dec 2006 7:38 PM

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

17 Dec 2006 1:46 AM

RobinS

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.
--------------------------------------------
Show quote

"fredd00" <frederic.nou***@gmail.com> wrote in message
news:1166297881.312402.36140@80g2000cwy.googlegroups.com...
> 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
>

18 Dec 2006 7:20 AM

fredd00

I would like to see both tables in the designer

RobinS wrote:
Show quote

> 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.
> --------------------------------------------
> "fredd00" <frederic.nou***@gmail.com> wrote in message
> news:1166297881.312402.36140@80g2000cwy.googlegroups.com...
> > 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
> >

18 Dec 2006 8:11 AM

RobinS

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

Robin S.
----------------------------------------

Show quote

"fredd00" <frederic.nou***@gmail.com> wrote in message
news:1166426453.839248.160380@80g2000cwy.googlegroups.com...
>I would like to see both tables in the designer
>
> RobinS wrote:
>> 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.
>> --------------------------------------------
>> "fredd00" <frederic.nou***@gmail.com> wrote in message
>> news:1166297881.312402.36140@80g2000cwy.googlegroups.com...
>> > 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
>> >
>

17 Dec 2006 6:54 PM

W.G. Ryan eMVP

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.
Show quote

"fredd00" <frederic.nou***@gmail.com> wrote in message
news:1166297881.312402.36140@80g2000cwy.googlegroups.com...
> 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
>