Click here to Skip to main content
15,890,947 members
Home / Discussions / C#
   

C#

 
AnswerRe: parsing Pin
Guffa17-Oct-07 11:44
Guffa17-Oct-07 11:44 
GeneralRe: parsing Pin
s3rro17-Oct-07 14:54
s3rro17-Oct-07 14:54 
QuestionDataGridView: How to fit column size Pin
AndrusM17-Oct-07 8:30
AndrusM17-Oct-07 8:30 
QuestionQueue Dequeue Pin
s3rro17-Oct-07 7:56
s3rro17-Oct-07 7:56 
AnswerRe: Queue Dequeue Pin
Giorgi Dalakishvili17-Oct-07 8:13
mentorGiorgi Dalakishvili17-Oct-07 8:13 
QuestionODBC Pin
half-life17-Oct-07 6:52
half-life17-Oct-07 6:52 
AnswerRe: ODBC Pin
Giorgi Dalakishvili17-Oct-07 7:12
mentorGiorgi Dalakishvili17-Oct-07 7:12 
QuestionSQL SELECT statement problem in TableAdapter configuration wizard C#. Pin
antony_t17-Oct-07 6:30
antony_t17-Oct-07 6:30 
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 | :mad:







QuestionRe: SQL SELECT statement problem in TableAdapter configuration wizard C#. Pin
TJoe17-Oct-07 7:26
TJoe17-Oct-07 7:26 
Questionsine wave ? Pin
james_dixon_200817-Oct-07 5:52
james_dixon_200817-Oct-07 5:52 
AnswerRe: sine wave ? Pin
Luke_ICS17-Oct-07 6:44
Luke_ICS17-Oct-07 6:44 
AnswerRe: sine wave ? Pin
User 665817-Oct-07 9:03
User 665817-Oct-07 9:03 
AnswerRe: sine wave ? Pin
Ennis Ray Lynch, Jr.17-Oct-07 10:05
Ennis Ray Lynch, Jr.17-Oct-07 10:05 
QuestionExtract Exe's Pin
t4ure4n17-Oct-07 5:28
t4ure4n17-Oct-07 5:28 
AnswerRe: Extract Exe's Pin
Giorgi Dalakishvili17-Oct-07 5:34
mentorGiorgi Dalakishvili17-Oct-07 5:34 
GeneralRe: Extract Exe's Pin
t4ure4n17-Oct-07 22:17
t4ure4n17-Oct-07 22:17 
QuestionValidate NT user in Asp.Net Web page Pin
Elena200617-Oct-07 4:07
Elena200617-Oct-07 4:07 
AnswerRe: Validate NT user in Asp.Net Web page Pin
led mike17-Oct-07 4:35
led mike17-Oct-07 4:35 
AnswerRe: Validate NT user in Asp.Net Web page Pin
Pete O'Hanlon17-Oct-07 4:36
mvePete O'Hanlon17-Oct-07 4:36 
QuestionKiosk Mode Pin
kingletas17-Oct-07 3:54
kingletas17-Oct-07 3:54 
AnswerRe: Kiosk Mode Pin
Luke_ICS17-Oct-07 4:43
Luke_ICS17-Oct-07 4:43 
AnswerRe: Kiosk Mode Pin
TJoe17-Oct-07 6:05
TJoe17-Oct-07 6:05 
GeneralRe: Kiosk Mode Pin
kingletas18-Oct-07 6:32
kingletas18-Oct-07 6:32 
AnswerRe: Kiosk Mode Pin
Dan Neely17-Oct-07 7:12
Dan Neely17-Oct-07 7:12 
GeneralRe: Kiosk Mode Pin
kingletas18-Oct-07 6:35
kingletas18-Oct-07 6:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.