473,396 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Data Relation Update

I have a datarelation between two tables and I'm having trouble making this
work. I call an addnew on the datarelation to create my new record. However,
I'm having trouble updating my child table. I haven't found any reasonable
examples to do this. Anyone have any suggestions??
Mar 2 '06 #1
4 1409
"Andrew Bassett" <Fl******@community.nospam> schrieb
I have a datarelation between two tables and I'm having trouble
making this work. I call an addnew on the datarelation to create my
new record. However, I'm having trouble updating my child table. I
haven't found any reasonable examples to do this. Anyone have any
suggestions??

I don't understand how you call addnew on a relation.

Some links (maybe you know this already):

http://msdn.microsoft.com/library/en...terdataset.asp

http://msdn.microsoft.com/library/en...datatables.asp
In addition, there's this ADO.Net group:
microsoft.public.dotnet.framework.adonet

Armin

Mar 2 '06 #2
Essentially I have a binding source that was created off of a data relation.
When I add records I see them being added to the list however the changes
never seem to make it to the underlying dataset. Does this help clear thinsg
up?

"Armin Zingler" <az*******@freenet.de> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
"Andrew Bassett" <Fl******@community.nospam> schrieb
I have a datarelation between two tables and I'm having trouble
making this work. I call an addnew on the datarelation to create my
new record. However, I'm having trouble updating my child table. I
haven't found any reasonable examples to do this. Anyone have any
suggestions??

I don't understand how you call addnew on a relation.

Some links (maybe you know this already):

http://msdn.microsoft.com/library/en...terdataset.asp

http://msdn.microsoft.com/library/en...datatables.asp
In addition, there's this ADO.Net group:
microsoft.public.dotnet.framework.adonet

Armin

Mar 2 '06 #3
Hi Andrew,

This might have something to do with the data binding on the form. Did you
bind the controls correctly to the underlying DataSet? Please check the
follwing samples for more information on data binding.

http://msdn.microsoft.com/library/de...us/cpqstart/ht
ml/cpsmpnetsamples-windowsformsdatabinding.asp

You can also take a look at the following articles on data relations.

http://msdn.microsoft.com/library/de...us/vbcon/html/
vbconintroductiontodatasetrelations.asp

http://msdn.microsoft.com/library/de...us/dv_vbcode/h
tml/vbtskcodeexamplecreatingdatarelation.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Mar 3 '06 #4
"Andrew Bassett" <Fl******@community.nospam> schrieb
"Armin Zingler" <az*******@freenet.de> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
"Andrew Bassett" <Fl******@community.nospam> schrieb
I have a datarelation between two tables and I'm having trouble
making this work. I call an addnew on the datarelation to create
my new record. However, I'm having trouble updating my child
table. I haven't found any reasonable examples to do this.
Anyone have any suggestions??

I don't understand how you call addnew on a relation.

Some links (maybe you know this already):

http://msdn.microsoft.com/library/en...terdataset.asp

http://msdn.microsoft.com/library/en...datatables.asp
In addition, there's this ADO.Net group:
microsoft.public.dotnet.framework.adonet


Essentially I have a binding source that was created off of a data
relation. When I add records I see them being added to the list
however the changes never seem to make it to the underlying dataset.
Does this help clear thinsg up?

I've no idea. I don't use data binding. Maybe because of these problems.
Armin

Mar 3 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Edward | last post by:
Access 2k -> SQL Server 2k My client has an app that is A2k FE with A2k BE. They have asked me to move the BE to SQL Server. I have a bit of experience with SQL Server, and I'm happy with...
4
by: teddysnips | last post by:
This is a rather abstract question about data design, but I ask it here because a) the database is SQL Server, and b) you're such a learned bunch! Let's assume the classic relation of Customers...
4
by: Showjumper | last post by:
Do you all create dedicated data access layers for each project or do you create resuable ones that you can use over many projects. Also, in the data access layer, do you all create specific...
11
by: Thomas A | last post by:
Hi, I fill a datgrid with data from a xml document, it works fine But.... Now I will to filter the data to the grid so only the data shows from the criteria that I set. My code now is very...
13
by: nyt | last post by:
I have a problem of number and text field. I got the database file(mdb) that contains many combo boxes used and its list values are created by "value list" For eg field Field name= 'furniture'...
15
by: philip | last post by:
On a form, I have a datagridview. This datagridview is constructed on a dataset filled by a tableadapter. The table adapter do very well what it must do when filling dataset. Insertions,...
5
by: sutphinwb | last post by:
Hi - This could be a simple question. When I relate two tables in a datasetet, how do I get that relation to show up in a GridView? The only way I've done it, is to create a separate table in the...
9
by: Anil Gupte | last post by:
After reading a tutorial and fiddling, I finally got this to work. I can now put two tables created with a DataTable class into a DataRelation. Phew! And it works! Dim tblSliceInfo As New...
7
by: erikcw | last post by:
Hi, I'm working on a web application where each user will be creating several "projects" in there account, each with 1,000-50,000 objects. Each object will consist of a unique name, an id, and...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.