• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

mysql insert staement not working

here is the code Im using, code compiles without errors, but no records in DB

        Dim SqlString As String = "INSERT INTO profiles (nom, prenom, doorNumber, address) VALUES (" & TextBox1.Text & ", " & TextBox2.Text & ", " & TextBox8.Text & ", " & TextBox9.Text & ")"



        Try
            Using conn As New MySql.Data.MySqlClient.MySqlConnection(myConnectionString)
                Using cmd As New MySql.Data.MySqlClient.MySqlCommand(String.Format(SqlString), conn)
                    conn.Open()
                End Using
            End Using
        Catch ex As MySql.Data.MySqlClient.MySqlException
            MessageBox.Show(ex.Message)
        End Try
0
prowebinteractive
Asked:
prowebinteractive
1 Solution
 
VoteyDiscipleCommented:
Some of those variables look like strings, though, so I suspect you'll end up with a query like this:
INSERT INTO profiles (nom, prenom, doorNumber, address) VALUES (x y z, foo bar, 3, an address goes here);

That, clearly, isn't valid SQL.  Try:
        Dim SqlString As String = "INSERT INTO profiles (nom, prenom, doorNumber, address) VALUES ('" & TextBox1.Text & "', '" & TextBox2.Text & "', " & TextBox8.Text & ", '" & TextBox9.Text & "')"

(noting the quote marks around the variables I believe are strings -- naturally amend that to reflect which ones are ACTUALLY strings (-:  )
0
 
prowebinteractiveAuthor Commented:
I updated that issue but the query is still not happening
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now