Error executing the query in Visual Web Developer 2008

Asked By 10 points N/A Posted on -
qa-featured

Hi,

I am a web developer and started my work including a new web site with VS 2005 and added a sqldatasource and connect with the AdventureWorks sample database. I checked the connection working fine and save as “AdventureWorksConnectionString”. At the end I received an error message while testing query with 'test query' button . How can I remove this error? If you have any idea please share some ideas. Thanks.

Visual Web Developer 2008 Express Edition

There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.

Invalid object name ‘Product’.

SHARE
Answered By 0 points N/A #183451

Error executing the query in Visual Web Developer 2008

qa-featured

Hello Charlie,

I think you are getting this error message because of manual construction of the SQL select statement. I would advise you try the Query Wizard to build the select statement. Usually, the syntax is fieldname.tablename, maybe this is why you are getting the error. Also, when you use the wizard, most of the syntax based errors are taken care of.

Login/Register to Answer

Related Questions