Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / January 2006

Tip: Looking for answers? Try searching our database.

Table name in Dataset

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ant - 27 Jan 2006 02:57 GMT
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
Cor Ligthert [MVP] - 27 Jan 2006 07:07 GMT
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
Ant - 27 Jan 2006 08:45 GMT
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

> For the version 2005 users this is version 2003.
>
[quoted text clipped - 12 lines]
>
> Cor
W.G. Ryan - MVP - 27 Jan 2006 15:58 GMT
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
> Hi,
>
[quoted text clipped - 15 lines]
>
> Ant

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.