Re: How do I update child keys when I update their string data?
From: W.G. Ryan [eMVP] (WilliamRyanATGmailDotcom)
Date: 09/07/04
- Next message: DC Gringo: "output parameter values not displaying properly"
- Previous message: W.G. Ryan [eMVP]: "Re: adding a new datarow to a datalist at runtime?"
- In reply to: Wade: "How do I update child keys when I update their string data?"
- Next in thread: Wade: "Re: How do I update child keys when I update their string data?"
- Reply: Wade: "Re: How do I update child keys when I update their string data?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Sep 2004 19:12:35 -0400
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.
- Next message: DC Gringo: "output parameter values not displaying properly"
- Previous message: W.G. Ryan [eMVP]: "Re: adding a new datarow to a datalist at runtime?"
- In reply to: Wade: "How do I update child keys when I update their string data?"
- Next in thread: Wade: "Re: How do I update child keys when I update their string data?"
- Reply: Wade: "Re: How do I update child keys when I update their string data?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
