DataSet “Failed to enable constraints. One or more rows contain values….”

Loading several DataTables into a DataSet using DataRelations when there are invalid constraints causes the error message “Failed to enable constraints. One or more rows contain values….”.

Solution is documented here

[csharp]
foreach (DataTable dt in dataset.Tables)
{
if (dt.HasErrors)
{
Console.WriteLine(“ERRORS IN : ” + dt.TableName);
foreach (DataRow dr in dt.GetErrors())
{
Console.WriteLine(dr.RowError);
}
}
}
[/csharp]

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s