I would do it in your SQL query rather than in C#. select top 10 * from products order by newid() Try that on your northwind database and look at the difference if you leave off the order by newid(). Doing it with the SQL means that you don't have to pull back everything in your DS if your only looking for 10 random records. KingXango