not giving error in queries.....

Question

1.00/5 (1 vote)

See more:

hi there

in vb.net when i make mistakes in query then it's not giving error.

so how can i know what is the mistake in my query.

Posted 26-Sep-12 16:57pm

Aniruddh Bhatt

Add a Solution

Comments

Savalia Manoj M 26-Sep-12 23:16pm

Have you Add Try Catch Block? If Not then add and check.

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)

Tim Corey · Answer 1 · 2012-09-26T17:09:00

The simple answer here is that an error isn't being thrown or you are ignoring it. Don't forget that VB.NET isn't validating your SQL code (for the most part). Instead, SQL Server is doing that. Therefore, you won't get the same error events as you would in your code. Depending on how you are connecting to your SQL server, you can usually query the command object (I believe that is the one) to get error information.

Don't forget too that a SQL statement that returns the wrong information isn't an error. Otherwise it might be working and just not doing what you want it to do.

My suggestion is to run all queries in SQL and then copy them into VB.NET. Also, use Stored Procedures so you can make simple calls to the server.