delimiter //
create procedure proc_outdata(in num int,out count int)
begin
select * from User;
select count(*) into count from User;
end//
delimiter ;
private void button3_Click(object sender, EventArgs e)
{
//proc_outdata
string start = "";
MySqlParameter outParmCount = new MySqlParameter("@count", MySqlDbType.Int32)
{
Direction = ParameterDirection.Output
};
MySqlParameter[] parameters = {
new MySqlParameter("?num", 5),
outParmCount
};
DataSet ds = MySqlHelper.ExecuteDataSet(MySqlHelper.DBConnectionString, CommandType.StoredProcedure, "proc_outdata", parameters);
string outresult=parameters[1].Value.ToString();
string end = "";
}