Configuring a dataAdapter with a SQL statement

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

Date: Fri, 27 Aug 2004 15:57:03 -0700

I am filling a dataset in VB.NET with records from an Access database. I
want to fill the dataset with randomly chosen records. I have tested the
following SQL statement in Access and it works smashingly. Unfortunately not
when configuring my dataAdapter. Any ideas?

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

-- 
Jennifer Yellman Quynn
Motivational Assessment

Relevant Pages

  • Filling a dataset with random 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 ... Jennifer Yellman Quynn ...
    (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: Database Listing and Sorting
    ... I am a rookie and just filling in) ... > I was wondering if someone could give some quick advice on how to modify the ... > This is coming from an Access database using ODBC so the 'GetRecord' ... > shorten the display. ...
    (microsoft.public.vc.database)
  • Re: Could not lock file Error
    ... I am getting the error when i am filling my dataset (Line 73: ... >> i am trying to connect to an Access Database that resides on the C drive ... >> my computer and am trying to populate the dataset using the data i got ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How do I find the IP address using MS Access?
    ... person who is filling out the Online form which straightly gets in to my Access database in my web server. ...
    (microsoft.public.access.formscoding)