I have a problem trying to link my my datagrid view to my sql server stored procedure. The way it should work is that when I select an item in a list from my combo box it returns a set of rows on the datagrid view specific only to that item .
This is the code on the server sideCREATE PROCEDURE spCompanySearch
@Comp VARCHAR(50)
AS
BEGIN
SELECT * FROM Company
WHERE [COMPANY NAME] LIKE '%' + @Comp + '%''
END
The @comp is supposed to be each item in the combobox list but I don't know how to do it or how to go about it so please if anybody can help me I will be very grateful. Examples will be appreciated