SQL SELECT statement problem in TableAdapter configuration wizard C#.
-
Hi so im following a tutorial http://www.asp.net/learn/data-access/tutorial-01-cs.aspx. I'm trying to configure a TableAdapter Query in the configuration Wizard with a SELECT statement which has a WHERE clause at the end. I am about half way down the tutorial and have followed it word for word. I have entered: SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE CategoryID = @CategoryID But i am getting an error message on the last page of the config wizard saying: Generated SELECT statement. Error in WHERE clause near ‘@’. Unable to parse query text. Can anyone hazard a guess at what i'm doing wrong???:mad:
-
Hi so im following a tutorial http://www.asp.net/learn/data-access/tutorial-01-cs.aspx. I'm trying to configure a TableAdapter Query in the configuration Wizard with a SELECT statement which has a WHERE clause at the end. I am about half way down the tutorial and have followed it word for word. I have entered: SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE CategoryID = @CategoryID But i am getting an error message on the last page of the config wizard saying: Generated SELECT statement. Error in WHERE clause near ‘@’. Unable to parse query text. Can anyone hazard a guess at what i'm doing wrong???:mad:
If you replace "@CategoryID" with "?" (without the quotes), does it work?
Take care, Tom ----------------------------------------------- Check out my blog at http://tjoe.wordpress.com