how to set output parameter of mysqldataadapter

Question

p_maxsi is an output parameter but don't know how shall tell it to .net..

 MySqlDataAdapter msdadapter = new MySqlDataAdapter("usp_NewItemId_test", mysqlcon);
 msdadapter.SelectCommand.CommandType = CommandType.StoredProcedure;
 msdadapter.SelectCommand.Parameters.Add("p_maxsi", MySqlDbType.Decimal);
 // output parameter how
 msdadapter.Fill(dtbl);

Please help new to .NET

Answer 1

this lines helped me. thanks @vaibhav parmar

msdadapter.SelectCommand.Parameters.Add("p_maxsi", MySqlDbType.Decimal).Direction = ParameterDirection.Output;