CODEWITHSUNDEEP
mysqlvb.net
user4655559
user4655559

Reputation:

VB.NET MySQL Fatal Error But database accepts input

I get a fatal error when I execute this code, but the info still shows up in the database. Can anyone see an error here?

sql.RunQuery("INSERT INTO test(test1,test2,test3) values(?FName,?LName,?DOB)")

            sql.SQLcmd.Parameters.AddWithValue("?FName", Gender.SelectedItem)
            sql.SQLcmd.Parameters.AddWithValue("?LName", Age)
            sql.SQLcmd.Parameters.AddWithValue("?DOB", RDIAge)

            sql.SQLcmd.ExecuteNonQuery()

Upvotes: 0

Views: 40

Answers (1)

Hackerman
Hackerman

Reputation: 12295

Your code should looks like:

  Dim connString As String = "Database=yourDB;Data Source=localhost;";
  connString +="User Id=yourUserDb;Password=dbPass" 

  Dim conn As New MySqlConnection(connString)
  Dim cmd As New MySqlCommand()
  Try
    conn.Open()
    cmd.Connection = conn

    cmd.CommandText = "INSERT INTO test(test1,test2,test3) values(@FName,@LName,@DOB)"
    cmd.Prepare()

    cmd.Parameters.AddWithValue("@FName", Gender.SelectedItem)
    cmd.Parameters.AddWithValue("@LName", Age)
    cmd.Parameters.AddWithValue("@DOB", RDIAge)
    cmd.ExecuteNonQuery()

    conn.Close()

  Catch ex As MySqlException
      Console.WriteLine("Error: " & ex.ToString())
  End Try

Upvotes: 0

Related Questions