C# shuffle one column out of two

[yandroide]

Hi, I am having trouble shuffling a column out of two. This is my original table below in Ms Access.

ID_EMPLOYEE ID_STATION
ALAD DECH
FRED DECI
MIKE ORR
PAM OR
RAK ORW
RAYN PROC

I would like to shuffle ID_STATION and have something different at every run. For example:

ID_EMPLOYEE ID_STATION
ALAD ORW
FRED PROC
MIKE DECI
PAM DECH
RAK OR
RAYN ORR

I am using visual studio 2012 with c#. I created a List called scheduleList in my class SCHEDULE which contains properties like sEmployeeID and sStationID . I fill the list as follow:

List scheduleList = new List();
//Populating Schedulelist from database
foreach (DataRow row2 in tschedule.Rows)
{
sEmployeeID = row2["ID_EMPLOYEE"].ToString();
sStationID = row2["ID_STATION"].ToString();
scheduleList.Add(new SCHEDULE(sEmployeeID, sStationID));
}

All I want now is a code to shuffle my ID_STATION only.

[Lost User]

Create a table that holds "all possible values" or "testset" that can go into the ID_STATION, use RANDOM to fetch the values for your insert.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[thanh_bkhn]

You could do this as below: 1. Create a new List to store all values of ID_STATION 2. Use Random class to generate a random index from 0 to upper bound value of the above List 3. Add the value corresponding to this index into a new List 4. Remove the value from the old List 5. Repeat from 2 until the old List become empty. 6. Update every record in your table Update tableName set ID_STATION = stationList[i] where ID_EMPLOYEE = employeeList[i]

"Never memorize something that you can look up." - Albert_Einstein