Cita:
egun esta forma hay alguna forma que pueda recuperar el call aaa_output('34','34');Try
Dim objConnection As New MySqlConnection
Dim comando As New MySqlCommand
objConnection = New MySqlConnection(ConfigurationManager.ConnectionStr ings("ConnectionSigcol1").ConnectionString)
comando.Connection = objConnection
comando.CommandType = CommandType.StoredProcedure
comando.CommandText = "aaa_output"
comando.Parameters.Add("param_cod_empresa", MySqlDbType.VarChar, 5).Value = "et"
comando.Parameters("param_cod_empresa").Direction = ParameterDirection.Input
comando.Parameters.Add("param_des_empresa", MySqlDbType.VarChar, 45)
comando.Parameters("param_des_empresa").Direction = ParameterDirection.Output
objConnection.Open()
comando.ExecuteNonQuery()
objConnection.Close()
TextBox1.Text = comando.Parameters("param_des_empresa").Value
Catch ex As MySqlException
TextBox1.Text = "error"
End Try
Dim objConnection As New MySqlConnection
Dim comando As New MySqlCommand
objConnection = New MySqlConnection(ConfigurationManager.ConnectionStr ings("ConnectionSigcol1").ConnectionString)
comando.Connection = objConnection
comando.CommandType = CommandType.StoredProcedure
comando.CommandText = "aaa_output"
comando.Parameters.Add("param_cod_empresa", MySqlDbType.VarChar, 5).Value = "et"
comando.Parameters("param_cod_empresa").Direction = ParameterDirection.Input
comando.Parameters.Add("param_des_empresa", MySqlDbType.VarChar, 45)
comando.Parameters("param_des_empresa").Direction = ParameterDirection.Output
objConnection.Open()
comando.ExecuteNonQuery()
objConnection.Close()
TextBox1.Text = comando.Parameters("param_des_empresa").Value
Catch ex As MySqlException
TextBox1.Text = "error"
End Try
para asi enviar el error al encargado de la base de datos de antemano gracias, porque digitar por ejemplo store de 60 parametros seria algo epsado la verdad