[RESOLVED] Stored Procedure from Sub issue

[BrailleSchool]

Hi all,

I am trying to modify a sub I have (that works) to use a stored procedure instead.

My stored procedure is as follows:

CREATE PROCEDURE sp_GetOperatingSystem
@Manufacturer INT,
@OSType INT
AS
BEGIN
SET NOCOUNT ON;
 
SELECT OperatingSystem.OperatingSystemName,
       OperatingSystem.ManufacturerID_PKFK,
       OperatingSystem.OperatingSystemTypeID_PKFK,
       OperatingSystem_Manufacturers.ManufacturerID_PK,
       OperatingSystem_Type.OperatingSystemTypeID_PK
FROM OperatingSystem
INNER JOIN OperatingSystem_Manufacturers
ON OperatingSystem.ManufacturerID_PKFK = OperatingSystem_Manufacturers.ManufacturerID_PK
INNER JOIN OperatingSystem_Type
ON OperatingSystem.OperatingSystemTypeID_PKFK = OperatingSystem_Type.OperatingSystemTypeID_PK
WHERE OperatingSystem.ManufacturerID_PKFK = @Manufacturer
AND OperatingSystem.OperatingSystemTypeID_PKFK = @OSType
ORDER BY OperatingSystem.OperatingSystemName
END
GO

The way I use the sub is as follows:

Select Case cboOperatingSystemType.Text
                    Case "Server"
                        PopulateDropDownListDLL.PopulateDropDownListFromDB_WithWhereClauseX2(cboOperatingSystem, _
                                                                                             2, _
                                                                                             1, _
                                                                                             My.Settings.NewConnectionString)
                    Case "Workstation"
                        PopulateDropDownListDLL.PopulateDropDownListFromDB_WithWhereClauseX2(cboOperatingSystem, _
                                                                                             2, _
                                                                                             2, _
                                                                                             My.Settings.NewConnectionString)
                End Select

The following screen shot shows my problem. I don't know what I am supposed to do. Any ideas? Thanks

[BrailleSchool]

OK. stupid me. I figured it out. I did ," instead of ", with the parameters. Maybe I need to take a break