help! how to creat sqldataadapter?

[sunny]

when I use creat the sqldataadapter (database is northwind),I enter:

SELECT OrderID, ProductID, UnitPrice, Quantity, Discount
FROM [Order Details]
WHERE (OrderID IN
(SELECT orderid
FROM orders
WHERE customerid = @customerid))

and I click NEXT,I get:

generated SELECT statment.
must declare the variable '@customerid'


why??????anybody can help me?


Thank you a huge lot in advance.


sunny

 

[Cor]

Hi sunny

Have a look at

command.parameters

http://msdn.microsoft.com/library/d.../vbtskSettingGettingDataCommandParameters.asp

I hope this helps,

Cor