Hi
i have a form that the user enters the data and sme other information
but this date should be unique coz it is a primary key in the sql table,what i want to know is how to let a message show to tell the user that he entered duplicate values when he press save...
i knwo its using try...catch but i don't know the syntax.....would someone help....thanks in advance

You need to query the database and check for an existing record. Or you can just run the insert command and catch the returned exception that tells you that there is a violation of the primary key. I'd recommend running a check query first instead of letting the insert fail. My philosophy is that if a key violation is an expected condition then it's not an exception, so check for it.

-Peter

can u please help me with the syntax

What do you have so far?

-Peter