Adapter Wizard Part 2

Sam

Hi ther

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

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 erro
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 hel

Nov 20 '05 #1

Subscribe Post Reply

936

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

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

Nov 20 '05 #2

by: Dermot O'Loughlin | last post by:

Can anyone help me with this? I get the following error when using the odbc adapter wizard in VS.Net 2003: --------------------------- Wizard Form --------------------------- An unexpected...

.NET Framework

Stumped when using the Data Adapter Configration Wizard...

by: Vince Campanile | last post by:

Ive got what must bea very basic question, but its got ne thouroughly stumped. Im writing a very simple application in Visual Basic.Ne 2003, thats using a data adapter hooked up to an Access...

Visual Basic .NET

Data Adapter Configuration Wizard...

by: Rick | last post by:

The data adapter wizard allows you to add more than one table, but that doesn't seem to work right when setting up a dataset. Some of the documentation I have read states that only one table...

Visual Basic .NET

Table Adapter Configuration Wizard replaces data table name with stored procedure's

by: John | last post by:

Hi When using Table Adapter Configuration Wizard if 'Use SQL Statements' is selected as Command Type, the data table's name in dataset is retained and only its data adapter's select statements...

Visual Basic .NET

Slow Data adapter Configruation Wizard

by: Gshell | last post by:

When I get to the "Choose your data connection" screen and click the down arrow by the combo box, it takes several minutes (4 or more) to present my list of two pre-existing sources. (Both of...

Visual Basic .NET

writing data adapter sql commands

by: cj | last post by:

I'm having a problem writing an insert command to work with a datatable. I've looked at what the sqldataadapter creates and created my insert command to look the same. I have:...

Visual Basic .NET

Visual Studio 2005 and SQL Adapter Wizard

by: ocean | last post by:

Hi, I've installed Visual Studio 2005 on Windows XP/Home Edition. I had to modify some files in order to get IIS installed successfully. The problem I am having is that in Visual Studio 2005,...

ASP.NET

Is this a bug in the data adapter wizard?

by: Alan Pretre | last post by:

In VS 2003 when I use the Configure Data Adapter option in VS 2003 I get the size parameter to the SqlParameter set to the correct size for a varchar, for example, .... new...

C# / C Sharp

Issue with ASP 2's Table Adapter Wizard

by: David | last post by:

I have a SQLExpress database with a table that has a unique index. I am creating dataset/Table Adapter using the wizard. THe Wizard creates a select and insert commands, but does not create a...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics