Would someone please tell me how to get Visual Studio to automatically create the correct SQL statements so that I can stop getting the following error:"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'" 'Product' gets replaced with whatever table name I drag onto my web form from the server explorer. The only information that may help that I know is that I noticed that Visual Studio creates the following select statement: "SELECT * FROM [BillOfMaterials]" and this generates an error. Where as when I manually type "SELECT * from Production.BillOfMaterials;" Everything works fine. The only issue with this is i would hate to have to manually enter all of the SQL statement into my web app. Any help would me great appreciate. SQL2008.AdventureWorks_All_Databases.x64 - this is the version of AdventureWorks that I downloaded and installed on my machine.
View Complete Post