Problem in retrieving the data set

Question

0.00/5 (No votes)

See more:

Hi,

I want to retrieve the data by an id. But the following error occurs :

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

I checked every thing. Currently i am designing the system in mvc architecture. The query is working fine in DAL layer but when i want to access the query through webserver it returns the above error.

SQL

SELECT AttendeeName,AttendeeAddress,AttendeeContact,AttendeePayPalID,AttendeeDesignation,AttendeeUserID,AttendeePassword,AttendeeEmailID
From createAttendeeView
Where AttendeeID = @AttendeeID

And also my business logic code is :

C#

public DataSet wsGetAttendeeDetails(string AttendeeID)
        {
            DataSet ds = new DataSet();
            try
            {
                dt = attendeeview.getAttendeeDetailsByID(AttendeeID);

                if (dt.Rows.Count == 0)
                {
                    return null;
                }
                else
                {
                    ds.Tables.Add(dt);
                    return ds;
                }
            }
            catch (Exception ex)
            {
                ExceptionError er = new ExceptionError();
                er.errorMessage(ex.Message);
                throw;
            }      
        }

It does not enter into if loop and directly goes to catch and return the error. Please help me out of this.

Thanks..In advance

Posted 9-Jun-12 0:18am

rp786

Updated 9-Jun-12 1:01am

Sandeep Mewara

v2

Add a Solution

2 solutions

Solution 1

Have a look at these to troubleshoot:
ERROR : Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints [^]
How to: Troubleshoot “Failed to enable constraints. One or more rows contain values violating non-null[^]

Similar discussions:
http://www.devnewsgroups.net/adonet/t14842-failed-enable-constraints-one-more-rows-contain-values-violating-non-null-unique-foreign.aspx[^]
http://www.dotnet247.com/247reference/msgs/21/108864.aspx[^]
http://weblogs.asp.net/dmarsh/archive/2002/06/16/492.aspx[^]
http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/27aec612-5ca4-41ba-80d6-0204893fdcd1/[^]

Posted 9-Jun-12 1:08am

Sandeep Mewara

Comments

Maciej Los 20-Jun-12 7:40am

Good answer, my 5!

Sandeep Mewara 21-Jun-12 16:51pm

Thanks Mac!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rp786 · Accepted Answer · 2012-06-20T01:19:00

C#

public DataSet wsGetAttendeeDetails(string AttendeeID)
        {
            try
            {
                DataSet ds = new DataSet();
                SqlCommand cmd = new SqlCommand(string.Format("SELECT  AttendeeName, AttendeeAddress,AttendeeContact, AttendeePayPalID, AttendeeDesignation, AttendeeUserID FROM Attendee WHERE (AttendeeID = '{0}')", AttendeeID), con);
                con.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(sdr);
                con.Close();

                if (dt.Rows.Count == 0)
                {

                    DataTable table1 = new DataTable("Attendee");
                    table1.Columns.Add("Result");
                    table1.Rows.Add("Null");
                    ds.Tables.Add(table1);
                    return ds;
                }
                else
                {
                    ds.Tables.Add(dt);
                    return ds;
                }
            }
            catch (Exception)
            { 
                return null;
            }
        }