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.

enter image description here

I am setting the @m_id above??

Can you post all the code in the file that is throwing the exception? It appears you have a different command (cmd3) being built when an exception happens, which is not the ideal way to handle the logic to build different commands. Using structured exception handling to control logic flow in your application is asking for trouble. — Karl Anderson
– Karl Anderson, Commented Jul 8, 2013 at 15:03
@karl Thanks, i will look to touch that up now, i also agree that the flow is asking for trouble. It is working now thanks to George Johnston answer below, but i will neaten up and order the code. — Pomster
– Pomster, Commented Jul 8, 2013 at 15:10

George Johnston · Accepted Answer · 2013-07-08 14:49:49Z

7

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.

answered Jul 8, 2013 at 14:49

George Johnston

32.3k29 gold badges130 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related