private void RunStoredProcedure()
{
string customer_name = "";
var conn = new OdbcConnection();
conn.ConnectionString = @"DSN=ABCD;" +
"Uid=TAB;" +
"Pwd='******';
OdbcCommand command = new OdbcCommand("{? = CALL GETUSERNAME(?)}", conn);
command.CommandType = CommandType.StoredProcedure;
OdbcParameter parameter2 = new OdbcParameter();
parameter2.ParameterName = "v_username";
parameter2.OdbcType = OdbcType.VarChar;
parameter2.Size = 255;
parameter2.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(parameter2);
OdbcParameter parameter = new OdbcParameter();
parameter.ParameterName = "p_userid";
parameter.OdbcType = OdbcType.VarChar;
parameter.Direction = ParameterDirection.Input;
parameter.Value = "dsmith";
command.Parameters.Add(parameter);
conn.Open();
OdbcDataReader reader = command.ExecuteReader();
while (reader.Read())
{
customer_name = reader[0].ToString();
}
conn.Close();
MessageBox.Show(customer_name.ToString());
}