C# – EnforceConstraints Problem

cdataset

dsrm_usersTableAdapters.rm_usersIPTableAdapter _tuser = new dsrm_usersTableAdapters.rm_usersIPTableAdapter();

dsrm_users _dsuser = new dsrm_users();
_dsuser.EnforceConstraints = false;

dsrm_users.rm_usersIPDataTable _muser = _dsuser.rm_usersIP;
_tuser.FillBy(_muser, _IP);

it is very good works;

However, when I use ObjectDataSource and connect to grid view using GetData() method, it gives an error;

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

I go to the Dataset and I set EnforceConstraints=false in Property Window , and I try agin its give again same erorr. So EnforceConstraints=false does not work with GetDATA();

So what can I do now? How can I use ObjectDataSource using GetData() without this error.

Best Answer

I would first try and determine why your constraints are failing.

You can determine this by

_dsuser.EnforceConstraints = false;
//fill info
try
{
    _dsuser.EnforceConstraints = true;
}
catch
{
            if (ds.HasErrors)
            {
                DataRow[] drs = _dsuser.[datatablename].GetErrors();
                foreach(DataRow dr in drs)
                {
                    foreach(DataColumn dc in dr.GetColumnsInError())
                    {
                        Console.Write(dr.GetColumnError(dc));
                    }
                }
            }
}

This will print to the console any errors in the datatable

You can also loop thru' the tables with ds.tables if you do not know the table name.

Related Solutions

C# – What triggers ConstraintException when loading DataSet

Like many people, I have my own standard data access components, which include methods to return a DataSet. Of course, if a ConstraintException is thrown, the DataSet isn't returned to the caller, so the caller can't check for row errors.

What I've done is catch and rethrow ConstraintException in such methods, logging row error details, as in the following example (which uses Log4Net for logging):

...
try
{
    adapter.Fill(dataTable); // or dataSet
}
catch (ConstraintException)
{
    LogErrors(dataTable);
    throw;
}
...

private static void LogErrors(DataSet dataSet)
{
    foreach (DataTable dataTable in dataSet.Tables)
    {
        LogErrors(dataTable);
    }
}

private static void LogErrors(DataTable dataTable)
{
    if (!dataTable.HasErrors) return;
    StringBuilder sb = new StringBuilder();
    sb.AppendFormat(
        CultureInfo.CurrentCulture,
        "ConstraintException while  filling {0}",
        dataTable.TableName);
    DataRow[] errorRows = dataTable.GetErrors();
    for (int i = 0; (i < MAX_ERRORS_TO_LOG) && (i < errorRows.Length); i++)
    {
        sb.AppendLine();
        sb.Append(errorRows[i].RowError);
    }
    _logger.Error(sb.ToString());
}

.net – The EnforceConstraints property doesn’t seem to work

This is error not from Designer, this is error from Database.
In Designer you can just add another layer of constraint checks, but the main exception is from database.
Usually it bad practice to remove constraint because they are checks if Database contain correct data.

Best Answer

Related Solutions

C# – What triggers ConstraintException when loading DataSet

.net – The EnforceConstraints property doesn’t seem to work

Related Topic