Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

enter image description here

enter image description here

I am setting the @m_id above??

like image 576
Pomster Avatar asked Mar 24 '23 06:03

Pomster


1 Answers

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.

like image 180
George Johnston Avatar answered Apr 05 '23 22:04

George Johnston