By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,965 Members | 1,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,965 IT Pros & Developers. It's quick & easy.

DataSet Relations based on Views?

P: n/a
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?

Joe Sullivan
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.