Error adding parameters to SQL Server stored procedure though VB code?

Question

I am struggling to pass though parameter to a stored procedure I have written.

I’m really not sure what I am doing wrong here, but I’m struggling to get VB to pass parameters to SQL Server.

I am setting the @m_id above??

Answer 1

I would go out on a limb (because I don't see it in the above code) and say it's because you didn't set the cmd2.CommandType to StoredProcedure. By default, the command type is Text, which is used for inline SQL.