Buenas,
Me he creado un windows form con un formulario para poder añadir productos a mi aplicacion. Por cierto estoy con visual studio 2005 y programando con vb.net. Al final del todo esta el codigo pero cada vez que le doy click al boton me da este error :
" Incorrect syntax near 'Data' " y se va a la linea que pone "rowsAffected = cmd.ExecuteNonQuery"
Mi codigo es el siguiente :
Protected Sub bt_igo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bt_igo.Click
Dim _connectionString As String = ConfigurationManager.ConnectionStrings("DendaOnLin eConnectionString").ConnectionString
Dim sql As String = "INSERT INTO Produktuak([Id], [Izena], [Deskribapena], [Imagina], [Prezioa], [Stock], [Eskaintza]) VALUES (@Id,@Izena,@Deskribapena,@Imagina,@Prezioa,@Stock ,@Eskaintza)"
Dim cmd As New SqlCommand(sql)
Dim conn As SqlConnection = New SqlConnection(_connectionString)
cmd.CommandText = _connectionString
cmd.Connection = conn
Dim dbParam_id As New SqlParameter
dbParam_id.ParameterName = "@id"
dbParam_id.Value = txtId.Text
dbParam_id.DbType = System.Data.DbType.Int32
cmd.Parameters.Add(dbParam_id)
Dim dbParam_izena As New SqlParameter
dbParam_izena.ParameterName = "@Izena"
dbParam_izena.Value = txtIzena.Text
dbParam_izena.DbType = System.Data.DbType.String
cmd.Parameters.Add(dbParam_izena)
Dim dbParam_Deskribapena As New SqlParameter
dbParam_Deskribapena.ParameterName = "@Deskribapena"
dbParam_Deskribapena.Value = txtDeskribapena.Text
dbParam_Deskribapena.DbType = System.Data.DbType.String
cmd.Parameters.Add(dbParam_Deskribapena)
Dim dbParam_Imagina As New SqlParameter
dbParam_Imagina.ParameterName = "@Imagina"
dbParam_Imagina.Value = txtImagina.Text
dbParam_Imagina.DbType = System.Data.DbType.String
cmd.Parameters.Add(dbParam_Imagina)
Dim dbParam_Prezioa As New SqlParameter
dbParam_Prezioa.ParameterName = "@Prezioa"
dbParam_Prezioa.Value = txtPrezioa.Text
dbParam_Prezioa.DbType = System.Data.DbType.Int32
cmd.Parameters.Add(dbParam_Prezioa)
Dim dbParam_Stock As New SqlParameter
dbParam_Stock.ParameterName = "@Stock"
dbParam_Stock.Value = txtStock.Text
dbParam_Stock.DbType = System.Data.DbType.Int32
cmd.Parameters.Add(dbParam_Stock)
Dim dbParam_Eskaintza As New SqlParameter
dbParam_Eskaintza.ParameterName = "@Eskaintza"
dbParam_Eskaintza.Value = txtEskaintza.Text
dbParam_Eskaintza.DbType = System.Data.DbType.Int32
cmd.Parameters.Add(dbParam_Eskaintza)
Dim rowsAffected As Integer = 0
conn.Open()
Try
rowsAffected = cmd.ExecuteNonQuery
Finally
conn.Close()
End Try
End Sub
Gracias por la ayuda. Un saludo. aitiba
