Loop Through All DataTable in DataSet Using A For Loop

Question

5.00/5 (1 vote)

See more:

hi, does anyone know how do I loop through all datatable in dataset with a For Loop instead of foreach loop? I know foreach loop can do this but I want to use a For loop instead.

For example:

HTML

foreach (DataTable table in ds.Tables)
{
}

I would like to use a For Loop instead.

Appreciate if someone can help me on this. Thanks !

Regards,

Felicia

Posted 28-Sep-15 23:00pm

Member 11999641

Updated 28-Sep-15 23:14pm

Naveen.Sanagasetti

v2

Add a Solution

3 solutions

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)

Palash Mondal_ · Accepted Answer · 2015-09-28T23:12:00

Solution 3

You can do:

C#

DataSet ds = new DataSet();
for (int count = 0; count < ds.Tables.Count; count++)
{
    // Get individual datatables here...
    DataTable table = ds.Tables[count];
}

Posted 28-Sep-15 23:12pm

Palash Mondal_

Suvendu Shekhar Giri · Accepted Answer · 2015-09-28T23:10:00

Solution 2

By simply using Dataset.Tables.Count property

C#

for (int i=0; i< ds.Tables.Count;i++)
{
   //your logic goes here
}

Why don't you want to use foreach, any specific reason?
I would like to recommend to use foreach over for loop unless there is any specific requirement.

Hope, it helps :)

Posted 28-Sep-15 23:10pm

Suvendu Shekhar Giri

Updated 28-Sep-15 23:14pm

v3

Krunal Rohit · Accepted Answer · 2015-09-28T23:07:00

Solution 1

C#

for(int i=0; i < ds.Tables.Count; i++)
{
    // TODO:...
}

-KR

Posted 28-Sep-15 23:07pm

Krunal Rohit

Updated 29-Sep-15 1:24am

v2

Comments

Suvendu Shekhar Giri 29-Sep-15 5:13am

If I am not wrong, it should be i < ds.Tables.Count if i is intialized to 0 else i need to be initialized to 1.

Krunal Rohit 29-Sep-15 5:21am

Depends on your requirements.

-KR

Suvendu Shekhar Giri 29-Sep-15 5:29am

In what kind of requirement you think it will be useful?
The loop will be executed for "no of tables in dataset"+1 times, isn't it?
Can you please share such a requirement for reference? Thanks !