Thread: '?companyname' not found in the collection.

I have a SPROC in MySQL

Code:

DELIMITER $$
DROP PROCEDURE IF EXISTS `GetCompany` $$
CREATE PROCEDURE `GetCompany`(
companyref INT,
companyname VARCHAR (60)
)
BEGIN
SET @ref = companyref;
SET @companyname = companyname;
SELECT
companies.companyref,
companies.name,
companies.web,
companies.domain,
companies.dtAdded,
companies.ipadd,
companies.addedBy,
CONCAT(users.forename,' ',users.surname) AS addedByUser
FROM companies
LEFT JOIN users ON companies.addedBy=users.userref
WHERE
companies.companyref=if(@ref=0,companies.companyref,@ref) AND
companies.name=if(ISNULL(@companyname),companies.name,@companyname)
;
END $$
DELIMITER ;

which is called from my .NET code like so.

Code:

Dim conn As New MySqlConnection(mybwGlobal.connString)
            Dim mycomm As New MySqlCommand("GetCompany", conn)
            mycomm.CommandType = Data.CommandType.StoredProcedure
            Dim rs As MySqlDataReader
            Using conn
                Using mycomm
                    Try
                        mycomm.Parameters.Add(New MySqlParameter("companyref", ref))
                        Dim nameP As New MySqlParameter("companyname", MySqlDbType.VarChar)
                        If String.IsNullOrEmpty(name) Then
                            nameP.Value = DBNull.Value
                        Else
                            nameP.Value = name
                        End If
                        conn.Open()
                        rs = mycomm.ExecuteReader
                        If rs.HasRows Then
                            rs.Read()
                            newCompany = New Company(rs("companyref"), rs("name"))
                        End If
                        rs.Close()

However, when it executes I get an error System.ArgumentException: Parameter '?companyname' not found in the collection.

I just don't understand why it's not working...Any ideas?

This error is produced by MySql or .Net?

May be you need to add this parameter to mycomm

Originally Posted by micky

This error is produced by MySql or .Net?

May be you need to add this parameter to mycomm

It's a MySQL error....

I think you could be right m. I hadn't added in to the command object.
Needed to add

Code:

mycomm.Parameters.Add(nameP)

That seems to have sorted it...Thanks m...

cool........ glad i cud help