vb6 Bulk Insert into a database

Question

0.00/5 (No votes)

See more:

VB6

SQL

VB6 : Is there any way to insert bulk ResultSet rows into a database, instead of using the loop.

Posted 7-Jul-13 21:08pm

Sams13

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)

_Asif_ · Answer 1 · 2013-07-07T21:44:00

Solution 1

What i understood from your question is that you want to builk insert data in some table in the database. If this is what you want then yes you can do that. You could build an xml that contain the data that you want to insert and pass it to a stored procedure. In that stored procedure you can insert rows in one go using XML suported inserts. Hopes this could solve your problem.

Posted 7-Jul-13 21:44pm

_Asif_

Comments

Sams13 8-Jul-13 4:01am

I am asking if there are a better way to insert data from resultSet into sql table rather than using the looping

Do While rs.EOF = False
cmdCommand.CommandText = "INSERT INTO tblAccount(FULL_NAME) VALUES ( '" & rs.Fields(0).Value & "')"
cmdCommand.Execute (cmdCommand)
rs.MoveNext
Loop

_Asif_ 8-Jul-13 4:14am

To my understanding there is no bulk insert support command object. You can do something like this.

var xml as string
Do While rs.EOF = False
xmlstring = xmlstring + "<full_name value="" & rs.Fields(0).Value & "">"
rs.MoveNext
Loop

cmdCommand.CommandText = "SP_BULK_INSERT"
'Pass xml parameter to SP_BULK_INSERT
cmdCommand.Execute (cmdCommand)