searinggaspain
Wed Sep 08 14:13:30 CDT 2004
"W.G. Ryan [eMVP]" <WilliamRyanATGmailDotcom> wrote in message news:<eXJzHCTlEHA.1656@TK2MSFTNGP09.phx.gbl>...
> If I understand you correctly, you don't want to use joins. Instead, pull
> over two separate queries and link them with a DataRelation.
>
http://www.knowdotnet.com/articles/datarelation.html
> Then you can call Update on each table/dataSet respectively.
> "Wade" <searinggaspain@hotmail.com> wrote in message
> news:21e5fd27.0409071103.379ad81d@posting.google.com...
> > I'm new to VB .NET and I've made an Access database with several
> > one-to-many relationships. I want to display the data in a datagrid
> > and give users the ability to edit the database. It's simple enough
> > to import the database into a DataSet and display the string data that
> > the keys point to using SQL INNER JOIN statements, but once the data
> > has been updated, how do I use the new string data values to update
> > the child keys that need to be returned to the database? Do I need to
> > import the parent tables in their entirety and make a relational
> > dataset? If anyone could point me to some example code that would be
> > very helpful.
Thanks for the reply. That helped me structure my DataSet properly.
When I preview the data I can tell that it's all related the way it's
supposed to be, but it's kind of backwards from the way I want it,
i.e. right now each record in a parent table shows all the records
(which are in another table) containing its respective key, but I want
to look at that other table, in which each record contains several
child keys from several parent tables, and instead of seeing those key
numbers, I want to see the data from the parent table that the key
points to. This is probably an elementary issue, but I can't find how
to do it.