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

DataSet Relations based on Views?

Using C# in Visual Studios .NET, I have created a Dataset
with 2 tables (created from an SQL Data Adapter). These
2 tables are loaded from 2 views in SQL Server 2000. I
am trying to create a relationship between these 2 tables
in the DataSet, but I keep getting an error at runtime
when executing the Fill procedure of the data adapter:

"Additional information: Failed to enable constraints.
One or more rows contain values violating non-null,
unique, or foreign-key constraints."

I am positive that the data in the views fit this
relation, so what I was wondering is if it has anything
to do with the data coming from views?

If not, then does anyone have any clues as to why I keep
getting this error?

Thanks,
Joe Sullivan
Jul 19 '05 #1
0 1575

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

Similar topics

0
by: Frosty | last post by:
Hi I am using the VS xsd designer to create a strongly typed dataset. The dataset is apparently successfully created, with no warnings or errors given. Is it not then to be expected that this...
2
by: Tommy Lang | last post by:
I am creating a database application that uses the dataset. The dataset holds three different tables. I can access each table, no problem there. But how can I combine data from the different...
4
by: Oscar Thornell | last post by:
Hi, I have a relativley large/complex typed dataset that contains 7-8 tables and some supporting relational tables (lookups) for many-to-many relations. A good exampel would be a dataset that...
6
by: Lars Netzel | last post by:
I have a VB.NET application based on MS access 2000 db. I have a 1 to many relation between 4 tables... tbl1 -> tbl2 -> tbl3 -> tbl4 (all with "one to many" relations) I need to create a...
0
by: Joe Sullivan | last post by:
Using C# in Visual Studios .NET, I have created a Dataset with 2 tables (created from an SQL Data Adapter). These 2 tables are loaded from 2 views in SQL Server 2000. I am trying to create a...
2
by: Joe | last post by:
Hi I have a dataset with 3 tables and 2 relations Is there a way to when I am at 1 row to tell if there is a relation on that row ??? I have the code hardcoded but try to make it work if the #...
2
by: Joe | last post by:
Hi I am going to receive a dataset downstream and I will not know the the fields number of field relations number of relations So I have to be flexible to take unknown data and be able to...
0
by: kevlar | last post by:
I am having some problems reading xml into a dataset and having it set up the datatables within it properly. i serialize an object into xml and read that xml into the dataset and the code i am...
2
by: Henrik | last post by:
Hi, I'm really stuck with this one. I have a dataset with two tables. One table is company data, and the other is contacts. I populate these by using a SP in SQL Server which returns the two...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.