Re: DataRelations vs Joins

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Kenneth Allen (kendrhyd_at_sympatico.ca)
Date: 12/18/04 

Date: Sat, 18 Dec 2004 09:12:23 -0500

Another consideration is whether or not the data will require the
ability to be modified and updated back into the database using the
Update() call on a DataAdapter - in that case a relation is also
recommended. If you want to code any update logic yourself, then the
JOIN can be used.

Note that the use of a JOIN does not eliminate the ability to do any
updates back into the database via an adapter, but it does make the
coding more challenging and you will need to include more control
columns in the JOIN itself.

-ken

Nicholas Paldino [.NET/C# MVP] wrote:
> Phil,
>
> It depends on what your needs are. If you have a need for a
> parent/child relationship in your UI (you have to display it as such), then
> a DataRelation is the way to go, as the responsibility of handling that
> related data is handled by the classes that handle data binding, and not by
> you.
>
> However, if you just need to display this in one place, and no need for
> a parent/child display, (where the child records are shown independent of
> the parent), then I would do the join on the server and return that.
>
> Hope this helps.
>
>

Relevant Pages

  • Re: Table data to a form in FP - Help
    ... Mayby I am just not thinking open and can't see an obvious solution. ... >Generally if you just want to display the data, without the ability to update it, then you would use ... You normal only use a form, it you want to allow the data to be updated in the database. ...
    (microsoft.public.frontpage.client)
  • Re-enabling display of Tools menu...
    ... Somehow I have lost the ability to see the View, Format ... and Tools menu in my Access 2000 Database. ... How do I allow the display of these items in my menu again? ...
    (microsoft.public.access.setupconfig)
  • selection from db and insertion into a form.
    ... display then. ... Then give the user the ability to double click on any ... database and to enable a click to load the info into a form page. ... Ryan McConnell ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)
  • Re: Picture property for Access 2K forms
    ... and it works great...until you look at the database size involved. ... or by simply scaling down the image display in the ... > supported by those filters. ... To associate a graphic file with an OLE Server, ...
    (microsoft.public.access.devtoolkits)