How Do I Get Rid Of This Error Sqlexception Was Unhandled

Question

1.00/5 (1 vote)

See more:

Friends,

The code in my Form shows an error
SQLException was unhandled
The pointer of the error is shown to the line below

Me.TableAdapterManager.UpdateAll(Me.CustomerDataSet1)

Thanks in advance

Posted 7-Sep-14 4:13am

olly2014

Add a Solution

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)

OriginalGriff · Accepted Answer · 2014-09-07T04:17:00

Solution 1

Start by putting a try...catch block around the code that generates the error and looking at the exception object it it returns. It (or the InnerException) should give you more information about exactly what the DB server is finding wrong.

When you know that, you can start looking for why it's complaining, but at least you will have some information to go on - unlike us...

Posted 7-Sep-14 4:17am

OriginalGriff

Comments

olly2014 7-Sep-14 10:51am

Outstanding Reply...Thankyou very much (OriginalGriff)
The application started working..
Highly appreciate your support..
Kind Regards Olly

OriginalGriff 7-Sep-14 10:57am

You do realize that just adding the try...catch gets rid of the error message, but it doesn't get rid of the problem? If it's round an INSERT operation that fails, it means the row(s) weren't added to the DB...

Yes, of course *you* do - but you'd be surprised how many people think getting rid of the error message gets rid of the problem! :laugh:

olly2014 7-Sep-14 11:36am

Appreciate your comment(OriginalGriff)
As your rightly said the error got elimanted and the application could save the contents(data) of the file. However, after closing the application and restarting it the data vanishes off. Hope, you may be having some clue. Thanks In advance

OriginalGriff 7-Sep-14 12:04pm

As I said, getting rid of the message didn't get rid of the problem.
You need to look at the Exception object that the Catch gives you and see what it says that the DB is having a problem with: it could be an invalid column content, a bad date, or anything else at this point. Only looking at the Exception itself will tell you.