Question

C# 怎么调Mysql带inout参数的存储过程？

procedure prc(in a int,out b int,inout c int)
begin
........
end

C#怎么调这个存储过程？

Answer 1

string MyConString = "..."
OdbcConnection conn = new OdbcConnection(MyConString);

conn.Open();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_test";
OdbcParameter p1 = new OdbcParameter("t_count", OdbcType.Int);
p1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p1);

int i = cmd.ExecuteNonQuery();
TextBox1.Text = p1.Value.ToString();

conn.Close();

Answer 2

MySQL教程4 MySQL8运算符、函数、存储过程及新增数据类型 17.之创建带有IN和OUT参数的存储过程 学习猿地