I am developing a system in visual basic and using Mysql database engine
Currently I make inquiries from visual basic, but I want to change that for stored procedure, but the problem I have is that calling it from the visual application does not work, they could help me say that I have a bad code
Dim Conexion As New MySqlConnection
Dim cmd As New MySqlCommand()
Dim ms As String
Conexion.ConnectionString = "server=65.;database=...;user=..;password=...;"
Conexion.Open()
cmd = New MySqlCommand("Login", Conexion)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@_usuario", usuario)
cmd.Parameters("@_usuario").Direction = ParameterDirection.Input
cmd.Parameters.AddWithValue("@_passsword", password)
cmd.Parameters("@_passsword").Direction = ParameterDirection.Input
cmd.Parameters.AddWithValue("@_mensaje", MySqlDbType.String)
cmd.Parameters("@_mensaje").Direction = ParameterDirection.Output
cmd.ExecuteNonQuery()
ms = (cmd.Parameters("@_mensaje").Value)