title: Stored Procedures VB.NET MYSQL
body: <p>Hello I still having problems, it brings me DBnull and I tried the Store procedure and works. This is my code. If someone could help me I will appreciate.</p>
  
  <pre><code>        conexion.Open()
          command.Connection = conexion
          command.CommandText = "TraerPaisOrigen"
          command.CommandType = CommandType.StoredProcedure
  
          command.Parameters.AddWithValue("@Cod_Dua", TxtCodDUA.Text)
          command.Parameters("@Cod_Dua").Direction = ParameterDirection.Input
  
  
  
          command.Parameters.AddWithValue("@_PaisOrigen", MySqlDbType.VarChar)
          command.Parameters("@_PaisOrigen").Direction = ParameterDirection.Output
          command.ExecuteNonQuery()
  
          'XML_PaisOrigen is a String
  
          XML_PaisOrigen = command.Parameters(0).Value.ToString
  
  
  
  
          conexion.Close()
  </code></pre>
  
  <p>My Store Procedured</p>
  
  <pre><code>CREATE PROCEDURE TraerPaisOrigen( IN Cod_Dua INT, OUT _PaisOrigen VARCHAR(2))
  </code></pre>