Table name in Dataset

27 Jan 2006 2:57 AM

Ant

Hi,

When I create a typed dataset containing multiple relational tables using
Generate dataset, it creates a single set of records based on what was chosen
when setting up the data adapter. If I have an orders table, an orderItems
table, a customer table etc. set up in the DataAdapter, the dataset chooses
one of these tables names as the name that intellisense exposes as the set of
records. This can be changed manually when viewing the schema.

My question is, how does it choose which table name to use for this combined
set of columns?

Thanks for your thoughts on this

Ant

27 Jan 2006 7:07 AM

Cor Ligthert [MVP]

For the version 2005 users this is version 2003.

Ant,

Sorry I am always fighting with those names myself in 2003, however to
prevent confusing.
The generic strongly typed dataset is very much changed in the version 2005
from that in 2003.

By the way the version in 2003 is for me almost unchangable (I see this
because you write "generate dataset" what is not in 2005), that goes much
better in the version 2005 just by using the designer.

To give you a change on a less confusing answer.

Cor

27 Jan 2006 8:45 AM

Ant

Thanks Cor,
it doesn't really answer my question but at least I don't need to worry
about it in V2005 & it's also reassuring that others find this a bit querky.

Thanks
Ant

Show quoteHide quote

"Cor Ligthert [MVP]" wrote:

> For the version 2005 users this is version 2003.
>
> Ant,
>
> Sorry I am always fighting with those names myself in 2003, however to
> prevent confusing.
> The generic strongly typed dataset is very much changed in the version 2005
> from that in 2003.
>
> By the way the version in 2003 is for me almost unchangable (I see this
> because you write "generate dataset" what is not in 2005), that goes much
> better in the version 2005 just by using the designer.
>
> To give you a change on a less confusing answer.
>
> Cor
>
>
>

27 Jan 2006 3:58 PM

W.G. Ryan - MVP

Ant:

It chooses the names based on the schema information of the queries. However
you can change this and very well may want to. In addition, check out the
TableMappings and ColumnMappings collections. This lets you work with your
tables and columns abstracted from their 'real' db names which may make
manipulating them a little easier/clearer.

HTH,

Bill
Show quoteHide quote

"Ant" <A**@discussions.microsoft.com> wrote in message
news:E9EE3883-04D6-43C6-8E8D-5C1AA1E0529D@microsoft.com...
> Hi,
>
> When I create a typed dataset containing multiple relational tables using
> Generate dataset, it creates a single set of records based on what was
> chosen
> when setting up the data adapter. If I have an orders table, an orderItems
> table, a customer table etc. set up in the DataAdapter, the dataset
> chooses
> one of these tables names as the name that intellisense exposes as the set
> of
> records. This can be changed manually when viewing the schema.
>
> My question is, how does it choose which table name to use for this
> combined
> set of columns?
>
> Thanks for your thoughts on this
>
> Ant