C# foreach Loop Random Row

Question

0.00/5 (No votes)

See more:

C#

Hello,

How can I select a random row when running through a foreach loop of DataRows.

Thanks so much for the help.
RB

Posted 1-Feb-11 8:23am

RadioButton

Add a Solution

2 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)

fjdiewornncalwe · Answer 1 · 2011-02-01T08:26:00

Solution 2

Try reading a bit. Google is your friend

1,640,000 results... Try something. If you have issues at that point, ask something more specific. (i.e. Make an effort, please)

Posted 1-Feb-11 8:26am

fjdiewornncalwe

Updated 1-Feb-11 8:27am

v2

Comments

Nish Nishant 1-Feb-11 14:29pm

Ah, I thought by "random" he meant "an arbitrary" row.

fjdiewornncalwe 1-Feb-11 14:43pm

You're probably right, but I put this answer because the OP hasn't demonstrated any effort towards his solution as far as we can see. It was my not so subtle way of pulling more information out of him. :) (Your answer is very good, however, and if the OP turns out to be looking for the arbitrary answer you provide, you'll get the +5 from me.)

Nish Nishant 1-Feb-11 14:45pm

Yeah this is kinda like a mind game, where you try to guess what the OP really wants :-)

Sergey Alexandrovich Kryukov 2-Feb-11 20:09pm

I see two different understandings of the word "random".
Who cares? this OP's business.
Mine is to vote 5.
--SA

JOAT-MON · Answer 2 · 2011-02-01T09:12:00

Solution 3

Assume you have a table called tbl that has been filled and has rows:

C#

Random rndm = new Random();
DataRow rndm_row;

foreach(DataRow row in tbl.Rows)
{

     rndm_row = tbl.Rows[rndm.Next(0,tbl.Rows.Count - 1)];

     // Do something with rndm_row

}

Out of curiousity, why would you want to do that?

Posted 1-Feb-11 9:12am

JOAT-MON

Comments

RadioButton 1-Feb-11 15:18pm

Thank for the answer. I had not thought have that. Very simple. The reason why I want to do this is to select from a random set of auto responses stored in the db.

JOAT-MON 1-Feb-11 15:44pm

Oh, okay...what you really need is just the Random class, not the foreach loop. Foreach is just for doing an iterated walk of collections.