Dataset & Datareader

[Guest]

Hello,

How can I get Random data from Dataset or datareader


THanks

 

[Cor Ligthert [MVP]]

Mike,

How can I get Random data from Dataset or datareader

Can you explain more what you mean with this. (as well if you are talking
about if this is a winform or a webform application).

A dataSet uses a dataadapter to fill its tables, where the datadapter uses a
datareader object.

Cor

 

[Carlos J. Quintero [VB MVP]]

Unless your select statement has an "ORDER BY" clause, the data from the
database is not guaranteed to be ordered. If you really need things of
random nature, use the System.Random class of the .NET Framework.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

 

[Guest]

It just a normal winform and the dataset or datareader is getting data from a
table. how can I get random rows from this dataset or reader

 

[Cor Ligthert [MVP]]

Mike,

In addition from Carlos, the data is not ordered however the data will
always be supplied in the same way.

Every dataset has datatables which have rows. The rows is what you need to
get with the again as Carlos told used randomizer to get a number from 0 to
ds.tables(0).rows.count -1

http://msdn.microsoft.com/library/d...us/cpref/html/frlrfsystemrandomclasstopic.asp

A row is than
dim myrandowrow as datarow = ds.tables(0)(therandomizerfoundnumber)

I hope this helsp,

Cor