Insering records in access database usin visual basic 2008

Question

2.33/5 (3 votes)

See more:

Hi everybody

I just want to know how to know if the records has been inserted successfully after an sql query in visual basic 2008

Posted 23-Jun-11 23:06pm

nourbt

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 · 2011-06-23T23:12:00

Solution 1

Assuming it didn't throw an exception, then it should have worked. But the only way to be sure (if you are feeling seriously paranoid) is to issue a SELECT command and read the record back, then compare it with the data you just inserted.

Shouldn't need it though, and I'm not entirely sure what you will do if you find it isn't right...

Posted 23-Jun-11 23:12pm

OriginalGriff

Comments

nourbt 24-Jun-11 5:20am

Original Griff

My interest in checking that the insert has finished is that I need to close the current form and open another form when the insert has finished

Dave Kreskowiak 24-Jun-11 9:31am

Unless you're doing the insert operation on a background thread or using Async methods (not common), the call to execute the insert is a blocking call, so the insert is done when your code starts executing the next line of code.

nourbt 24-Jun-11 9:47am

OK guys i am with you but can anybody help me concerning how to hide the current form and load the other form at the time the query end execution.

I used
Formnew.show()
Me.hide()
but it is not what i need