When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL
Statement "Select Top X .....", it works and display the correct result,
however i cannot generate the select statement successfully....
what can i do? 6 2892
Whats the error?
"Norton" <no********@hotmail.com> wrote in message
news:ed*************@tk2msftngp13.phx.gbl... When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL Statement "Select Top X .....", it works and display the correct result, however i cannot generate the select statement successfully....
what can i do?
Whats the error?
"Norton" <no********@hotmail.com> wrote in message
news:ed*************@tk2msftngp13.phx.gbl... When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL Statement "Select Top X .....", it works and display the correct result, however i cannot generate the select statement successfully....
what can i do?
it only claims "There were errors configuring the data adapter."
and the SQL Statement is
"SELECT Top 10 Content, DateID, Title FROM SoHappy ORDER BY DateID DESC"
when i remove Top 10 , it works, donno y
Thx for your help ~
"CJ Taylor" <no****@blowgoats.com> ¦b¶l¥ó
news:10*************@corp.supernews.com ¤¤¼¶¼g... Whats the error?
"Norton" <no********@hotmail.com> wrote in message news:ed*************@tk2msftngp13.phx.gbl... When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL Statement "Select Top X .....", it works and display the correct result, however i cannot generate the select statement successfully....
what can i do?
it only claims "There were errors configuring the data adapter."
and the SQL Statement is
"SELECT Top 10 Content, DateID, Title FROM SoHappy ORDER BY DateID DESC"
when i remove Top 10 , it works, donno y
Thx for your help ~
"CJ Taylor" <no****@blowgoats.com> ¦b¶l¥ó
news:10*************@corp.supernews.com ¤¤¼¶¼g... Whats the error?
"Norton" <no********@hotmail.com> wrote in message news:ed*************@tk2msftngp13.phx.gbl... When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL Statement "Select Top X .....", it works and display the correct result, however i cannot generate the select statement successfully....
what can i do?
Norton,
Does the Top 10 contains null value which null is not allowed for this
field?
Thanks,
Cynthia
DDSE QA
-------------------- From: "norton" <no********@hotmail.com> References: <ed*************@tk2msftngp13.phx.gbl>
<10*************@corp.supernews.com>Subject: Re: Problems in using VS.Net 2003's DataAdapter Date: Wed, 7 Apr 2004 00:20:47 +0800 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: <#k**************@TK2MSFTNGP10.phx.gbl> Newsgroups: microsoft.public.dotnet.languages.vb NNTP-Posting-Host: 210006240068.ctinets.com 210.6.240.68 Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTF EED01.phx.gbl!TK2MSFTNGP08
..phx.gbl!TK2MSFTNGP10.phx.gblXref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:193597 X-Tomcat-NG: microsoft.public.dotnet.languages.vb
it only claims "There were errors configuring the data adapter."
and the SQL Statement is "SELECT Top 10 Content, DateID, Title FROM SoHappy ORDER BY DateID DESC"
when i remove Top 10 , it works, donno y
Thx for your help ~
"CJ Taylor" <no****@blowgoats.com> ¦b¶l¥ó news:10*************@corp.supernews.com ¤¤¼¶¼g... Whats the error?
"Norton" <no********@hotmail.com> wrote in message news:ed*************@tk2msftngp13.phx.gbl... > When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL > Statement "Select Top X .....", it works and display the correct
result, > however i cannot generate the select statement successfully.... > > > what can i do? > >
Norton,
Does the Top 10 contains null value which null is not allowed for this
field?
Thanks,
Cynthia
DDSE QA
-------------------- From: "norton" <no********@hotmail.com> References: <ed*************@tk2msftngp13.phx.gbl>
<10*************@corp.supernews.com>Subject: Re: Problems in using VS.Net 2003's DataAdapter Date: Wed, 7 Apr 2004 00:20:47 +0800 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: <#k**************@TK2MSFTNGP10.phx.gbl> Newsgroups: microsoft.public.dotnet.languages.vb NNTP-Posting-Host: 210006240068.ctinets.com 210.6.240.68 Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTF EED01.phx.gbl!TK2MSFTNGP08
..phx.gbl!TK2MSFTNGP10.phx.gblXref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:193597 X-Tomcat-NG: microsoft.public.dotnet.languages.vb
it only claims "There were errors configuring the data adapter."
and the SQL Statement is "SELECT Top 10 Content, DateID, Title FROM SoHappy ORDER BY DateID DESC"
when i remove Top 10 , it works, donno y
Thx for your help ~
"CJ Taylor" <no****@blowgoats.com> ¦b¶l¥ó news:10*************@corp.supernews.com ¤¤¼¶¼g... Whats the error?
"Norton" <no********@hotmail.com> wrote in message news:ed*************@tk2msftngp13.phx.gbl... > When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL > Statement "Select Top X .....", it works and display the correct
result, > however i cannot generate the select statement successfully.... > > > what can i do? > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gregor Valentin |
last post by:
Hi!
one Question. Is here anybody who had success in accessing a mySQL database
via the ODBCDataAdapter in the Visual Studio design view?
I get always Errors after creating the select...
|
by: BBFrost |
last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net
2003. At first things were looking ok, now problems are starting to
appear.
So far ...
(1) ...
|
by: Norton |
last post by:
When i try to use OleDbDataAdapter's QueryBuilder, when i type some SQL
Statement "Select Top X .....", it works and display the correct result,
however i cannot generate the select statement...
|
by: Richard |
last post by:
I have created a form which sets up a dataview. The form views one
record at a time using a currencymanager. This works fine. All my
text boxes bind.
However I have a combo box which gets its...
|
by: Ray Nimmo |
last post by:
This is driving me nuts, been at it now for the last week, anyone any ideas on wher im going wrong?
using a list box pipeLB and a date/time picker pDate, im trying to populate the list box with...
|
by: Franklin M. Gauer III |
last post by:
I create a simple DATAADAPTER in a webservice project. It creates the
UPDATE, INSERT, DELETE commands for me - no problem.
In vS2005 it creates these commands as RESOURCES in the RESX file (i.e....
|
by: Doug |
last post by:
If I am grabbing a lot of rows (say 10,000 from SQL) would I be helping
or hurting the network by using a DataReader? I would think helping
because it's really only returning 1 row at a time,...
|
by: ankz |
last post by:
Hi Guys
I have got 3 tables - in Access
Database with Student ID as primary Key in all and all tables are
linked with 1 to 1 relationship.
I have code the everying with manual program to...
|
by: koonda |
last post by:
Hi guys,
I am trying to create a web interface in C# using ASP.NET. The database being used is SQL Server. I have some problems loading the tables in the datalist controls. When I run the program...
|
by: tbo |
last post by:
The code below works fine to update my database by adding rows of data to my dataTable.
However when I use the same commands (changing the names of database, datatable and rows) with another...
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |