DataView SQL Equivalents Needed

From: Frederik (aerts_frederik_at_hotmail.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 14:55:44 +0100

Hi all,

Situation:
- I have a DataTable ["french"] in a DataSet ["lexicon"].
- The DataTable is filled with data from an Access mdb database.

Problems:
- I need a DataView for the DataTable that filters 5
  'random' records (SQL equivalent: "ORDER BY Rnd...").
- I need a DataView for the DataTable that filters the
  'top 10' records (SQL equivalent: "SELECT TOP...").

Thanks for your time,
Frederik

Loading