Hi there i am trying to develop a small windows desktop app, All it needs to do is query a sql2005 database look 4 whatever is in the TextBox and display it in a Grid View.
I am using VS2008 and VB
, what i have so far is a Dataset that pulls data from 2 tables then have a stored procedure that :
SELECT Customers.CustomerID, Customers.CompanyName, Products.ProductName
FROM Customers CROSS JOIN
WHERE (Customers.CustomerID = '22')
this works only 4 ID 22, then i did
WHERE (Customers.CustomerID = '" & TextBox1.Text"')did not work
WHERE (Customers.CustomerID = @CustomersId)
now where do i assign the @CustomerID=TextBox1.text??
thanks in advance
Got it it was same as Web form under buytton event.