its not about what time you get to work or how long your there, it's about what you do while your there!!

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: