displaying error in vb.net ( when entering duplicate values in sqlserver)

[srivalli]

HII
i have one table in vb.net form.
in that,i placed 3 columns and i made them unique constraints by writing the code in sql server as

CREATE TABLE AA
(
NAME VARCHAR(50 ) UNIQUE NOT NULL,
ID NUMERIC(9) UNIQUE NOT NULL,
ACCNO NUMERIC(9) UNIQUE NOT NULL
)

SO, a table is created in the back end

now from vb.net if i try to enter any duplicate values in vb.net , then an error is generated automatically, which i dont want.

i want to display an error using MESSAGEBOX FROM VB.NET.

THANK U

 

[hoverctafter]

Try

<place your code here>
Catch ex As OleDb.OleDbException

MsgBox(ex.Message)

End Try

Hope that helps
Happy coding
Hovercrafter!

 

[levyuk]

Ok the top part of this article might help you. http://www.4guysfromrolla.com/ASPScripts/PrintPage.asp?REF=%2Fwebtech%2Ftips%2Ft100901-1.shtml