Check value of MySQL Command Output Parameter in C#

theuncle...

SOLVED CLOSED ACTIVE ANSWERED
User: theunclevince
Posted: on Jun 21, 2025 05:15 AM
Forum: ASP.Net Basics
Answer: 1
Views: 1297

Hello there,

I need using the Parameter Direction Output from stored procedure of MySQL database in the GridView1_RowDataBound event.

If the value of Parameter Direction Output from stored procedure is not null in the corresponding column of the gridview they must write one otherwise zero

Any suggestion?

I don't know what to do.

cmd.Parameters.Add(new MySqlParameter("@spRetval", MySqlDbType.VarChar));
cmd.Parameters["@spRetval"].Direction = ParameterDirection.Output;

Joey

1 2

Reply
ANSWER
User: Joey
Replied: on Jun 21, 2025 06:43 AM
Report

Hi theunclevince,

Refer below code.

cmd.Parameters.Add(new MySqlParameter("@spRetval", MySqlDbType.VarChar));
cmd.Parameters["@spRetval"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
// Check the value of the output parameter.
if(!string.IsNullOrEmpty(cmd.Parameters["@spRetval"].Value.ToString()))
{
    // Write 1.
}
else
{
    // Write 0.
}

For more details refer below article.

How to return Output parameter from Stored Procedure in ASP.Net using C# and VB.Net

Check value of MySQL Command Output Parameter in C#

Company

Explore

Follow us

Contact Us