shuffle datatable rows

Question

3.75/5 (4 votes)

See more:

C#

Hi to all
How to shuffle datatable rows in C#?
Thanks

Posted 27-Dec-10 2:28am

javadi_84

Add a Solution

Comments

#realJSOP 27-Dec-10 8:29am

Ummm... why?

javadi_84 27-Dec-10 8:43am

I am using these data as input parameter of an algorithm and I want to run algorithm by same data but with different order

4 solutions

Solution 1

One way to do this shown here[^].

Posted 27-Dec-10 3:09am

Abhinav S

Comments

Dalek Dave 27-Dec-10 18:26pm

Yes, but why do it?

Abhinav S 27-Dec-10 23:47pm

Good question - DD.

Solution 2

Pick them in random order or randomize it after picking! Why to shuffle row in DB?

Posted 27-Dec-10 4:03am

Sandeep Mewara

Solution 4

What possible need do you have for random shuffling of the datatable rows?

The order is immaterial, so long as the data is there it can be pulled by the query.

The datatable is invisible to the user, and it is not important what order it is in.

Can you explain the reason you wish to do this?

Posted 27-Dec-10 12:27pm

Dalek Dave

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)

Khaniya · Accepted Answer · 2010-12-27T20:29:00

Solution 5

Increase a field in datatable with name say ShuffleID

make use of random number without repeater algorithm

suppose there is 100 rows in table

random algorithm might give you number like 10, 4, 99, 67
store this number to ShuffleID field

sort datatable by ShuffleID

Posted 27-Dec-10 20:29pm

Khaniya