For loop in asp .net (C#)

Question

1.00/5 (1 vote)

See more:

Hello Every one

I have a DataTable of 2100 records or more. I want to run a loop of 500 data.

So if i have a 1000 data than my loop will be of 2 or i have a 1500 data than my loop will be of 3

i have done this much of code but does't work

In below code dtRecepient is DataTable

for (int recepient = 0; recepient < dtRecepients.Rows.Count; recepient++)
{

}

Posted 16-Jul-14 22:49pm

Rahul JR

Updated 16-Jul-14 22:51pm

v2

Add a Solution

Comments

ArunRajendra 17-Jul-14 4:51am

So?

Rahul JR 17-Jul-14 5:12am

If i have 550 data in DataTable than my for will run 550 times but after every 500 data i have to assign a some different value to data

3 solutions

Solution 2

If you mean how many loops of 500 you have to do on, say, n records then here you are:

C#

int loops = n / 500;
int spare = n % 500;

spare gives you the number of the remaining records if n is not exactly divisible by 500 (e.g. n=2100 => spare=100).

Posted 16-Jul-14 22:59pm

CPallini

Solution 4

C#

int total = dtRecepients.Rows.Count;
int iterations = total/500;

for (int recepient = 1; recepient <= iterations; recepient++)
{

}

Posted 16-Jul-14 23:00pm

MMLTech

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)

Sharmanuj · Accepted Answer · 2014-07-17T01:08:00

use this approach to get the desired output,

int startIndex, endIndex, totalCount;
totalCount = dtRecepients.Rows.Count;
startIndex = 0; endIndex = 500;
if (totalCount < endIndex)
{
for(startIndex; startIndex }
else
{
DataTable dtDataTemp = dtRecepients.Clone();
while (endIndex < totalCount)
{
dtDataTemp.Rows.Clear();
if (endIndex > totalCount)
{ endIndex = totalCount; }
for (int stIndex = startIndex; stIndex < endIndex; stIndex++)
{
//do your stuff
}
startIndex = endIndex;
endIndex += 500;
}
if (startIndex < totalCount && totalCount < endIndex)
{
dtDataTemp.Rows.Clear();
if (endIndex > totalCount)
{ endIndex = totalCount; }
for (int stIndex = startIndex; stIndex < endIndex; stIndex++)
{
//do your stuff
}
startIndex = endIndex;
endIndex += 500;
}
}
}
else
{ }