How do I change the order for a bindingsource?

Question

Hi I am working with a bindingsource, but I need its items to be in a random order. Anyone know how to change the order of the items in a bindingsource?

Fredrik Roaldset · Answer

Hi I have now found a solution to my problem. Thank you for your time anyway.

Sam Hobbs · Answer

Okay then I will try to determine your requirements better by asking questions. What is the bindingsource? Is it a SQL Server table? Did you use the Data Sources window to create a data source and did you then drag the data source to the form or if not then how did you create the bindingsource? If the data source is a table, then do you need to store the order in the table or do you need to show the items in random order each time without storing the order in the database? What is the bindingsource for? Is it for a form? If so then what controls are using the bindingsource? Is the bindingsource used for a DataGridView or some other control such as that?

Fredrik Roaldset · Answer

I need them to be in a random order, as in a different order each time it is accessed. The random part, I have a fair idea of how to do. What I am struggling with is to change the order within the bindingsource at all. I am fairly new at this, so I'm sorry if I am a bit unclear.

Sam Hobbs · Answer

Please define random. Do you mean unspecified; whatever order that the items previosuly existed in, or do you mean an order that is explicitly random, such as would be done using a random number generator.?