Problems in using VS.Net 2003's DataAdapter

  • Thread starter Thread starter Norton
  • Start date Start date
N

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?
 
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 ~
 
Norton,

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

Thanks,
Cynthia
DDSE QA
--------------------
 
Back
Top