Hi friends,

I am doing a .NET Windows application.

I am working against a DB2 AS/400 database.

I have some tables where i have put some key restrictions.
I mean, for example i have 2 fiels in a table: name and address. The name i want to be unique. This restriction has a name, for example: "Name restriction".

The problem is that when I insert a row with a name, for example "Peter" and then I try to insert another row with the same name, "Peter", the IBM database says that exists a row with the same information. This is what i want and it is okey, But the problem is that i want to capture the restriction name: "Name restriction", to show it in the .NET application.

How can I do it? Any ideas?

Thanks.

hi

can u tell me how to connect and manipulate DB2 AS/400 database with .NET??

Ashu

Use the Connection Object and the Errors collection.