How to do a loop in inserting data in a compact SQL database?

Question

0.00/5 (No votes)

See more:

Hi there everyone, I'm quite new in c# and SQL and I just wanna know how to actually do a loop for inserting the same data into a database. I need to insert the same data into my database for a total amount of 5000 times. And for extra information, I'm using SQL compact edition (.sdf) type of database. Thanks in advance.(^_^)

Posted 6-Mar-12 13:50pm

nizam15

Add a Solution

Comments

[no name] 6-Mar-12 20:14pm

Why on earth would you want to do such a thing?

Orcun Iyigun 6-Mar-12 20:21pm

I totally agree, seems like he wants to learn it the hard way :)

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)

**Orcun Iyigun** · Accepted Answer · 2012-03-06T14:18:00

Solution 1

With a little bit of Google search you could have found an answer to your question. But anyways,

C#

int loopCount = 5000;
for (int i = 0; i < loopCount; i++)
{
  //Your DB insert code here
}

-OR-

C#

int counter = 0;
while (counter != loopCount)
{
  //Your DB insert code here
  counter++;
}

For more info on the loops check these links:
Loops Tutorial 1[^]
Loops Tutorial 2[^]

Good luck,
OI

Posted 6-Mar-12 14:18pm

Orcun Iyigun

Comments

nizam15 6-Mar-12 20:22pm

Thanks a bunch~

nizam15 7-Mar-12 0:50am

just a question..is there a way to fasten the data insertion. Because when inserting 20k of data, it will get really slow~

Orcun Iyigun 7-Mar-12 2:38am

Look into the bulk insert tools such as: Bulk Insert(T-SQL)[^] or SQLBulkCopy Class(.Net)[^].