November 18, 2008 10:28pm pst

1. TheLearn... 877,431
2. prairiedog 600,250
3. samtran0... 502,890
4. raterus 395,615
5. Velio 358,485
6. naspinski 333,394
7. BondinASP 262,503
8. tedbilly 257,435
9. Dhaest 250,813
10. ororiole 227,646
11. angelIII 224,028
12. jpaulino 219,455
13. dusion 194,423
14. ragi0017 188,549
15. TimCottee 181,460
16. NazoUK 177,133
17. TheMegaL... 162,729
18. HeoQue 160,388
19. Rejojohny 154,765
20. renjurdevan 144,162
21. emoreau 142,997
22. jcoehoorn 140,808
23. davrob60 137,715
24. GreenGho... 137,285
25. TechTiger... 137,174

1. TheLearn... 2,991,012
2. samtran0... 2,572,549
3. raterus 2,015,854
4. nauman_... 1,216,228
5. sammy1... 1,164,962
6. Rejojohny 1,098,584
7. mmarinov 996,221
8. scolja 960,492
9. lem2802 626,188
10. prairiedog 619,075
11. AerosSaga 600,606
12. Edwin_C 568,753
13. angelIII 535,760
14. TimCottee 523,790
15. tusharashah 517,701
16. Justin_W 489,746
17. GavinMan... 469,710
18. praneetha 449,555
19. Dhaest 445,808
20. YZlat 444,190
21. b1xml2 441,009
22. carl_tawn 418,381
23. DreamMa... 403,879
24. pratima_... 403,144
25. ihenry 396,673

06.03.2008 at 01:35AM PDT, ID: 23452410

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

3.8

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

Asked by giligatech in Programming for ASP.NET, C# Programming Language, SQL Server 2005

Tags: C#, ASP.NET, VB.NET

Hii all,
I have a table (attached the table creation code) which uses me for languages on the website.
I put this table on DataSet and when I'm trying to call it:
ASPNET_LocalizationResourcesTableAdapter adapter = new ASPNET_LocalizationResourcesTableAdapter();
dbAdmin.ASPNET_LocalizationResourcesDataTable dt = adapter.GetData();

It says:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Source Error:

Line 15615: this.Adapter.SelectCommand = this.CommandCollection[0];
Line 15616: dbAdmin.ASPNET_LocalizationResourcesDataTable dataTable = new dbAdmin.ASPNET_LocalizationResourcesDataTable();
Line 15617: this.Adapter.Fill(dataTable);
Line 15618: return dataTable;
Line 15619: }

What is the problem?

I've attached the table creation SQL code.
ThanksStart Free Trial

         
           
           
             SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ASPNET_LocalizationResources](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[resource_Code] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[resource_Name] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[resource_Value] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Comment] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_LocalizationResources] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

           
         

Keywords: Failed to enable constraints. One or m…

	Title
1	Foreign Key Constraint Question
2	Delete a foreign key
3	How to set up a foreign key using php…
4	Foreign Keys with MySql DB
5	Mysql how to drop a foreign key
6	Datasets, constraints

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

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

Asked by giligatech in Programming for ASP.NET, C# Programming Language, SQL Server 2005

Tags: C#, ASP.NET, VB.NET

About this solution