Execute Stored Procedure using Mysql and Visual

0

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)
    
asked by Hugo Rodriguez 12.03.2018 в 09:36
source

0 answers