title: ODBC connection to MySQL won't add values
body: <p>I'm trying to insert values from my asp.net application into my MySQL database.</p>
  
  <p>On the register page people can fill in <code>Name</code> and <code>Pass</code> and press submit.</p>
  
  <pre><code>Public Function InsertMember(ByVal objMember As Member) As Boolean
  
      myconn.Open()
  
      Dim cmd As New OdbcCommand("INSERT INTO member(Name, Pass) VALUES (@Name,@Pass)", myconn)
  
      cmd.CommandType = CommandType.Text
      cmd.Parameters.Add("Name", OdbcType.VarChar).Value = objMember.Name
      cmd.Parameters.Add("Pass", OdbcType.VarChar).Value = objMember.Pass
  
      cmd.ExecuteNonQuery()
  
      cmd.Dispose()
      cmd = Nothing
  
      myconn.Close()
      myconn.Dispose()
  
      Return True
  
  End Function
  </code></pre>
  
  <p>But all this does is add NULL values into my database.</p>
  
  <p>Any clues on what I'm doing wrong?</p>