Exception in asp.net

Question

1.00/5 (2 votes)

See more:

when i insert a data into the database using insert query in asp.net, i get an exception like primart_key constraint violated... But i want to show the error as Data already exists in database with out that exeception...

In Vb6 we can do this with comparing the exception error number but there is no error number in .net how to do this.....

Posted 18-Sep-11 20:01pm

Kishore Jangid

Add a Solution

Comments

Prerak Patel 19-Sep-11 2:04am

.Net has the exceptions.

Sergey Alexandrovich Kryukov 19-Sep-11 2:17am

Why this seems to be a problem? And forget about stupid error numbers. The were rendered obsolete by Barbara Liskov in 1970s. Remember in what year do you live.
--SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-09-18T20:13:00

Solution 1

Use try catch to catch SqlException.

VB

Try

Catch ex As SqlClient.SqlException
    ' check on ex.Number and display whatever you want

End Try

Posted 18-Sep-11 20:13pm

Prerak Patel

Comments

Pravin Patil, Mumbai 19-Sep-11 2:19am

Good answer....

Prerak Patel 19-Sep-11 2:23am

Thanks Pravin