How to call an Output Parameter from a Mysql stored procedure in ASP.NET

Question

I am having a problem returning an output parameter from a Mysql stored procedure into a ASP.NET Variable. I just want the ligne code to use in ASP to get that Parameter ! Thank you

It would be awesome if you could share a minimal reproducible example of your progress so far. — mjwills
– mjwills, Commented Jul 28, 2019 at 13:11

akg179 · Accepted Answer · 2019-07-28 13:13:00Z

1

let's suppose that there is a parameter named 'MyOutParam' which is an output type of parameter for your MySQL stored procedure. In that case what you will have to do is:

// here goes the logic of instantiating the command for a stored procedure

// cmd is the reference variable containing instance of SQLCommand
cmd.Parameters.Add(new MySqlParameter(“MyOutParam”, MySqlDbType.VarChar));
cmd.Parameters[“MyOutParam”].Direction = ParameterDirection.Output;         // this is how we declare the parameter to be of 'output' type.

cmd.ExecuteNonQuery();

// this is how we can get the value in the output parameter after stored proc has executed
var outParamValue = cmd.Parameters[“MyOutParam”].Value;

answered Jul 28, 2019 at 13:13

akg179

1,5791 gold badge8 silver badges15 bronze badges

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

3 Comments

mjwills Over a year ago

I suspect that code won't compile as is due to ”.

Ghilo Over a year ago

Thank you sir , i'll try it :)

Ghilo Over a year ago

Oh great it's work :) thank you very much for your help and support!

Collectives™ on Stack Overflow

How to call an Output Parameter from a Mysql stored procedure in ASP.NET

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related