Re: unable to add new column ConstraintException was unhandled by user

Troy wrote:
I added a new column to my table and I now receive this error
message. When I trie to simply fill my datatable.

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic (COM-based) ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may be
lucky enough to find a dotnet-knowledgeable person here who can answer your
question, you can eliminate the luck factor by posting your question to a
group where those dotnet-knowledgeable people hang out. I suggest

The new column did not effect the primary key of the table.
The new column is not yet populated with any values, the column is
set to unique = False
The column is set to AllowDBNull = True

I added another column to a diffrent table and ran into the same
problem, I populated values into the column via SQL enterprise
manager and everything worked, but I should not need to do this.

I don't understand how you are adding the column. Are you using ADO.Net or
EM to add it? This should be made clear when you post this question to the
appropriate group.

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the


Relevant Pages