Shuffle DataTable Rows by specific column C#

Question

I'm trying to shuffle DataTable rows by a specific column (campaign_id) in this example. I tried what's suggested in this question cannot shuffle rows of DataTable

but I need to be more specific as I mentioned,

Here is an example: this is the DataTable I have, it is sorted by campaign_id column

and I want the result to be (shuffling campaign_id) like this:

"at least not consecutive" but in your result there are consecutive — Tim Schmelter, Jan 22 '19 at 16:22
Well, if you cant show what you have tried, could you at least explain the rules for this sorting? It's not obvious — Tim Schmelter, Jan 22 '19 at 16:26
If you're truly shuffling the data, "which column" it's shuffled by shouldn't matter at all. — Mike G, Jan 22 '19 at 16:59
shuffling != alternating. So [edit] the question, what exactly do you want. — Alexander Petrov, Jan 22 '19 at 17:01
@B.Simboliq a better word for what you're trying to do would be "alternating" rather than "shuffling" — Mike G, Jan 22 '19 at 17:28

score 1 · Answer 1 · answered Jan 22 '19 at 16:58

1

var rnd = new Random();
var shuffled = dataTable.Rows.Cast<DataRow>().OrderBy(r => rnd.Next()).CopyToDataTable();

answered Jan 22 '19 at 16:58

Alexander Petrov

13,457
2
20
49

Shuffle DataTable Rows by specific column C#

1 Answers1