GridView - SQLDatasource trouble

Hello,

I have a connection (server explorer), connected to "AdventureWorks"
database, the connection is ok.

I drop a table a page (design).

I want to configure datasource by click on "Configuire Data Source" in the
"Gridview Tasks"

Select the connection string : OK  ... next
Select a table and all the columns OK (the select statement created is
SELECT * FROM [Address]) ... Next

I wan test the query by clicking "Test Query" but i receive this error :
There was an error executing query. Please check syntax of the command and
if present, the types and values of the parameters and ensure they are
connected. Invalid object name 'address'

Any idea ?  The connection works, the syntax look ok.

I'm using SQL Server Express SP2 + VS 2005

Regards,

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com