Hi, id like to retrive a DataSet from an Access database of say 15 records that can be displayed in random order. To clarify, i mean I want the whole list in random order, not a single random item from the list(that would be easy 
At the moment I am doing this in ASP by using GetRows() to fill an array with the data, then Creating a second array with a 0-n index, shuffling it's contents, then using this in a loop to pick the records out of the first array. I hope with .net I can simplify this. Can I do it within ADO.NET or do I have to use an array again. If so could you give me any pointers on how the .Sort() method could be used.<BR><BR>Best regards<BR><BR>Paul
At the moment I am doing this in ASP by using GetRows() to fill an array with the data, then Creating a second array with a 0-n index, shuffling it's contents, then using this in a loop to pick the records out of the first array. I hope with .net I can simplify this. Can I do it within ADO.NET or do I have to use an array again. If so could you give me any pointers on how the .Sort() method could be used.<BR><BR>Best regards<BR><BR>Paul