Re: DataRelation

From: John Wood (spam_at_isannoying.com)
Date: 06/27/04 

Date: Sat, 26 Jun 2004 23:12:22 -0400

Oh... well datarelations aren't really that useful if you want your database
to be scalable, are they.... You'd think they'd somehow link it up to the
sqlcommandbuilder, given that it has the columns it needs to request the
data.

Thanks. 

-- 
     John Wood
     EMail: first name, dot, second name at priorganize.com
"EijiTek" <eijitek@comcast.net> wrote in message
news:yv2dneKYwKdhskPdRVn-uw@comcast.com...
> The data relation object only creates a relationship between the in-memory
> tables.  In your example, if the customer table has been populated but the
> orders table is empty, calling the GetChildRows() method of any given
> DataRow will return an empty array.  No data will be automatically
> downloaded since the data table has no knowledge of the origin of the data
> (ie: did the data come from a database via a DataAdapter or was it
manually
> added?).
>
> "John Wood" <spam@isannoying.com> wrote in message
> news:OqAfMz%23WEHA.2792@TK2MSFTNGP10.phx.gbl...
> > When you set up a DataRelation, does the data need to already be present
> in
> > the table, or will it query dynamically to fill up the data to fulfill
the
> > relationship?
> >
> > eg.
> > Customer is the parent table, orders it the child table.  Orders is
empty.
> > I navigate from Custom to Order using a DataRelation, will it
> automatically
> > send out the SQL to request the related orders?
> >
> > -- 
> >      John Wood
> >      EMail: first name, dot, second name at priorganize.com
> >
> >
> >
>
>

Relevant Pages

  • select statement and DataSet
    ... in the database which have a one to many relation ... will the returned DataSet contains any DataRelation between these two ... One customer can have many orders. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DataRelation
    ... The data relation object only creates a relationship between the in-memory ... if the customer table has been populated but the ... DataRow will return an empty array. ... > When you set up a DataRelation, does the data need to already be present ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: what to do
    ... If the "Customer" field of the record is empty, would not the box be also empty or open? ... Simply query you database for the Customer name field being blank or not. ... I want it to somehow pick up the information that the box is closed when I input a new customer into the access database. ...
    (microsoft.public.office.misc)
  • How to update databound textboxes in parent child datarelation
    ... who knows how to update the 'child' textboxes in a datarelated situation ... Parent-Child Datarelation on field CustomerId ... I.e. Customer FISSA doesn't yet have Orders. ... supplied) to customer FISSA the Orders textboxes are empty. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: daMyDatatable.Update fails for linked dataset tables (using Ol
    ... > example you should see that the Customer update occurs before the Orders ... the DataRelation I have defined in my ... > corresponding Order to the Customers and Orders DataTables of the dataset ... >> You can't use a CommandBuilder if you have a join in the Sql Statement. ...
    (microsoft.public.dotnet.framework.adonet)