GridView - SQLDatasource trouble

G

Gabriel

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,432
Messages
2,571,680
Members
48,796
Latest member
Greg L.

Latest Threads

Top