[Resolvido] Insert into (VB.NET)

[Lívia Rodrigues 1]

Galera, to inciando agora com .NET e to tentando fazer um formulário de cadastro.

Mas fica aparecendo o seguinte erro:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','TESTANDO)' at line 1

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 

Exception Details: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','TESTANDO)' at line 1

 

 

 

O código parece estar certo, da uma olhada:

 

Imports MySql.Data.MySqlClient

Public Class cadastro_de_clientes
   Inherits System.Web.UI.Page

   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

   End Sub

   Protected Sub ImageButton2_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton2.Click

       Dim nome As String
       Dim sobrenome As String

       Dim conexaoMySQL As MySqlConnection
       Dim myAdapter As New MySqlDataAdapter
       ' Dim dsMySQL As DataSet
       Dim strSQL As String

       nome = TextBox1.Text
       sobrenome = TextBox2.Text


       'Conexao banco de dados
       conexaoMySQL = New MySqlConnection("server=xxx.xxx.xx.x; user id=user; password=senha; database=name")

       Try
           conexaoMySQL.Open()
       Catch myerror As MySqlException
           MsgBox("Erro de conexao com o BD")
       End Try
       strSQL = "insert into usuarios (nome,sobrenome) values (" + nome + "','" + sobrenome + ")"


       Dim myCommand As New MySqlCommand()
       myCommand.Connection = conexaoMySQL
       myCommand.CommandText = strSQL

       'Iniciar Query
       myAdapter.SelectCommand = myCommand
       Dim myData As MySqlDataReader

       myData = myCommand.ExecuteReader()


       myData.Close()

   End Sub
End Class

 

 

To tentando descobrir o que pode ser, nao entendi muito bem a mensagem de erro, quem puder ajudar da uma forcinha.

Obrigada.

[Fernando C 128]

Msg d erro bem clara:

problema c/ a instrução SQL (comando "Insert");

sintaxe correta e outras dicas boas aqui:

http://www.linhadecodigo.com.br/artigo/2975/Comandos-b%C3%A1sicos-em-SQLinsert-update-delete-e-select.aspx

[Lívia Rodrigues 1]

Valeu fernando, ja havia resolvido.

O problema era simples, dei bobeira.

 

Bastou trocar o + por &

 

obrigada