473,394 Members | 1,840 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,394 software developers and data experts.

relationship in typed dataset (VS2005)

Efi
we have a typed dataset with 2 tables - parent and child with relation and
foreign key constraint.

after adding 1 parent row to the parent table with 1 related(!) child row to
the child table we have the following problem that never occured in VS2003:
both new rows states (each one in it's table) is "added", but after adding
the parent row to the parent table, it automatically changes the state of the
new child row to "modified" instead of added, apparently due to the relation
that changed the foreign key(?).

again, in VS2003 all this worked fine. the only difference that we saw
between 2003 and 2005 is the update rule, delete rule etc, that were
"(default)" in 2003 and now they are "Cascade" because the value "(defualt)"
doesn't exist anymore.
we also tried to change them to any of the other options but the only thing
we managed to achieve is that the child row state will remain "Added" but the
foreign key value won't be updated in this row after the parent row was
inserted.

Quick solution will be very appreciated.

Thanks in advane.

Mar 12 '06 #1
1 1717
Hello,

I am not very clear about what you said about:

but after adding the parent row to the parent table, it automatically
changes the state of the new child row to "modified" instead of added,
apparently due to the relation that changed the foreign key(?).

It means add the parent row seperately? Or add after child row? Can you
explain this in details?

Thanks,

Luke Zhang
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Mar 13 '06 #2

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

Similar topics

0
by: nima | last post by:
Hi I have two tables in my database. PRODUCT and PRODUCT_GROUP. PRODUCT has a foreign key to PRODUCT_GROUP. I generated a typed dataset using VS.net and added a relationship between the two...
0
by: mateo | last post by:
So here i've made a typed dataset in vs2005 by picking some tables in the server explorer. It generated a typed dataset with everything inside it ok. Now i've decided to put this newly created...
0
by: Liming | last post by:
Hi, I designed a few DataSet Tables in the typed dataset dsigner. Recently, I encountered an error saying Failed to enable constraints. One or more rows contain values violating non-null,...
7
by: Bob | last post by:
Hi, I have a typed unbound dataset that is passed to a datahandling class to be filled. The datahandling class fills it from a sproc using an oledbDataAdapter (SQLAnywhere database) The only...
13
by: Rotsey | last post by:
Hi, I have created a typed dataset (xsd file) with 2 tables and a relation between them in VS2005. How I do I now bind that dataset to a Gridview?? When i do this the page is blank.
21
by: Peter Bradley | last post by:
Hi all, This post is sort of tangentially related to my earlier posts on configuration files for DLLs. Does anyone know how to create typed DataSets using VS2005's new DataSet designer, but...
2
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
When I'm debugging a Windows Forms Application in VS2005 IDE, how can I check whether a dataset is strongly typed or not in Watch window? Are there some properties or methods only exist for...
12
by: BillE | last post by:
I'm trying to decide if it is better to use typed datasets or business objects, so I would appreciate any thoughts from someone with more experience. When I use a business object to populate a...
0
by: drhoades66 | last post by:
I have books, authors and a bkauthlink table linking the other two tables-a many-to-many relationship. I have tried various things but cannot create a Data Relation. Is there no way to do this in...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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.