I'm having trouble populating a datagrid when a user selects an item. Nothing shows up in the grid and think it's because of my SQL statement joining two tables:
Const strSQL_SUPPLIER_SELECTED As String = "SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice, " & _
"UnitsInStock, UnitsOnOrder, ReorderLevel, ProductDiscontinued FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID WHERE SupplierID = '"
I then have the entre SQL query as str_SQL_SUPPLIER_SELECTED & cboSuppliers.SelectedValue.ToString & "'"
When I debug it the SelectedValue is '18'. Any ideas?