*- ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Column count doesn't match value count at row 1
Estara mal mi codigo o mi base de datos?????????
Codigo Fuente:
Cita:
Ando medio perdido en esto si me pueden orientar que es lo que sale mal Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.Odbc
Public Class frmRegistro
Public conexionBD As OdbcConnection
Dim Resultado As String
Dim SQL As OdbcCommand
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conexionBD = New OdbcConnection("Dsn=conecta;server=localhost;uid=r oot;database=test;port=3306")
conexionBD.Open()
SQL = New OdbcCommand("INSERT INTO alumno(nombre,apellidop,apellidom,matricula) VALUES (1 ,' " & TextBox1.Text & "' , '" & TextBox2.Text & "' , '" & TextBox3.Text & "' , '" & TextBox4.Text & "')")
SQL.Connection = conexionBD
SQL.ExecuteNonQuery()
MsgBox("Los Datos se han registrado correctamente")
conexionBD.Close()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
End
End Sub
Private Sub frmRegistro_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
MaximizeBox = False
MinimizeBox = False
End Sub
End Class
Imports System.Data.SqlClient
Imports System.Data.Odbc
Public Class frmRegistro
Public conexionBD As OdbcConnection
Dim Resultado As String
Dim SQL As OdbcCommand
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conexionBD = New OdbcConnection("Dsn=conecta;server=localhost;uid=r oot;database=test;port=3306")
conexionBD.Open()
SQL = New OdbcCommand("INSERT INTO alumno(nombre,apellidop,apellidom,matricula) VALUES (1 ,' " & TextBox1.Text & "' , '" & TextBox2.Text & "' , '" & TextBox3.Text & "' , '" & TextBox4.Text & "')")
SQL.Connection = conexionBD
SQL.ExecuteNonQuery()
MsgBox("Los Datos se han registrado correctamente")
conexionBD.Close()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
End
End Sub
Private Sub frmRegistro_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
MaximizeBox = False
MinimizeBox = False
End Sub
End Class
