Home  |  Index  |  Dotnet4all Snippets  |  Submit resources
About  |  Mail us  
Dotnet4all Logo

  Adapter Wizard Part 2 (Thursday, January 06, 2005)




Found the following interesting discussion in the Newsgroups:

Adapter Wizard Part 2
by:Anonymous

Hi there

SELECT TOP 10 House, LivingRoom, DiningRomm, Den, [Date], FamilyRoom, BedRoom1, BedRoom2, Notes, [Number], Kitchen, Deck FROM MyRecords ORDER BY Number DESC

I have a data adapter I am trying to configure and when I enter the aboue query in the Adapter Wizard Dia box it says there is an error
The aim is to fill a dataset with only the last ten rows of data in decending order. Ironicaly, when I enter the same statement into OleDbCommand, it works.
Please help



 Reply:
by:Cor Ligthert

 Hi Sam,

What is ironicly with that, that is what I messaged you in your original
thread.

Please stay in the original thread.

Cor








 
Previous Posts
    - Reading the Flash File(.SWF) information
    - Passing value to windows form user control
    - Question on future compatibility between VB.NET an...
    - Retrieving files of filesystem
    - Reading Binary Coded Decimal in VB2003.net
    - VB.Net
    - Help with Structure conversion to VB.NET
    - Populating cboBox using txtFile
    - Information about (un)plugging USB device
    - How to run a form in vb dot net with the form name...

Archives
    - 08/01/2004 - 08/08/2004
    - 08/08/2004 - 08/15/2004
    - 08/15/2004 - 08/22/2004
    - 08/22/2004 - 08/29/2004
    - 08/29/2004 - 09/05/2004
    - 09/05/2004 - 09/12/2004
    - 09/12/2004 - 09/19/2004
    - 09/19/2004 - 09/26/2004
    - 09/26/2004 - 10/03/2004
    - 10/03/2004 - 10/10/2004
    - 01/02/2005 - 01/09/2005
    - 01/09/2005 - 01/16/2005
    - 01/30/2005 - 02/06/2005
    - 01/01/2006 - 01/08/2006


Disclaimer & Terms of Use  | DotNet4All.Com concept & © 2004 - 2007 by  Zelders²  - Holland