Filling a dataset with random records

From: Jenny Yellman (jaquynn_at_ihmail.com.donotspam)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 16:11:02 -0700

I am filling a dataset in VB.NET with randomly chosen records from a table in
an Access Database. I use the following SQL statement that works perfectly
when I test it out in Access. Unfortunately, it does not work the same way
when I use it to configure my dataAdapter in VB.NET

SELECT Problem
FROM tblX
WHERE (Skill = ?)
ORDER By Rnd(ID)

Any ideas?

Thanks,
Jennifer Yellman Quynn
Motivational Assessment 

-- 
Jennifer Yellman Quynn
Motivational Assessment

Relevant Pages

  • Configuring a dataAdapter with a SQL statement
    ... I am filling a dataset in VB.NET with records from an Access database. ... want to fill the dataset with randomly chosen records. ... Jennifer Yellman Quynn ...
    (microsoft.public.data.ado)
  • Re: Filling a dataset with random records
    ... Please reply only to the newsgroup so that others can benefit. ... > an Access Database. ... > Jennifer Yellman Quynn ... > Motivational Assessment ...
    (microsoft.public.data.ado)
  • Filling a dataset with randomly chosen records
    ... I am filling a dataset in VB.NET with randomly chosen records from a table in ... an Access Database. ... I use the following SQL statement that works perfectly ...
    (microsoft.public.access.queries)
  • Re: how do you update a java.sql.date type in an ms access database
    ... > when i update a row in an access database the date field ... DateTime data type in Access/Jet is more like a java.sql.Timestamp. ... Well, partly, but you're not using the date AS a date in the SQL statement, ... but as a String. ...
    (comp.lang.java.help)
  • Nothing is random
    ... The following SQL statement works perfectly well in Access, ... WHERE (Skill = ?) ... Jennifer Yellman Quynn ...
    (microsoft.public.data.ado)