468,539 Members | 1,451 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

Problems in using VS.Net 2003's DataAdapter

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?
Nov 20 '05 #1
6 2680
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?

Nov 20 '05 #2
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?

Nov 20 '05 #3
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> 在郵件
news:10*************@corp.supernews.com 中撰寫...
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?


Nov 20 '05 #4
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> 在郵件
news:10*************@corp.supernews.com 中撰寫...
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?


Nov 20 '05 #5
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> 在郵件
news:10*************@corp.supernews.com 中撰寫...
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?
>
>




Nov 20 '05 #6
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> 在郵件
news:10*************@corp.supernews.com 中撰寫...
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?
>
>




Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gregor Valentin | last post: by
10 posts views Thread by Richard | last post: by
1 post views Thread by Franklin M. Gauer III | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.