How to send bulk record step by step in C#

Question

0.00/5 (No votes)

See more:

I have 5000 records in list so i have to send first 1000 record then in next iteration next 1000 record ie 1001 to 2000 in this way i have to send all the record step by step

What I have tried:

i have treid for loop but its not working for me

Posted 15-Jun-16 20:44pm

Aviinash

Updated 15-Jun-16 21:11pm

Add a Solution

Comments

BillWoodruff 16-Jun-16 2:56am

"i have treid for loop but its not working for me"

So, single step through the code and describe the errors or what happened that you did not expect to happen, or, what did not happen that you expected to happen.

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 · Answer 1 · 2016-06-15T21:11:00

Assuming this is to a database...
There are a load of ways to do this, but the simplest is probably to create a DataTable, load it with 1000 rows, and use the SqlBulkCopy Class (System.Data.SqlClient)[^] to load it to the DB.
There is an example of using SqlBulkCopy here: Multiple SQL INSERT Operations with a Single Command[^] which may be of help.