Problems in using VS.Net 2003's DataAdapter

[Norton]

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?

 

[CJ Taylor]

Whats the error?

 

[norton]

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 ~

 

[Cynthia Lau[MSFT]]

Norton,

Does the Top 10 contains null value which null is not allowed for this
field?

Thanks,
Cynthia
DDSE QA
--------------------