System.Data.OleDb.OleDbException' en System.Data.dll {"No se han especificado valores para algunos de los parámetros requeridos.

Function Modificar(ByVal id As String, ByVal nombre As String, ByVal direccion As String, ByVal edad As String, ByVal telefono As String, ByVal sueldo As String, ByVal digito As String) As Boolean
    'convertir datos cadenas a numeros 
    Dim xid As Integer = Convert.ToInt32(id)
    Dim xedad As Integer = Convert.ToInt32(edad)
    Dim xsueldo As Integer = Convert.ToDouble(sueldo)
    'crear conexion
    Dim conexion As New OleDbConnection
    conexion.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = C:\Proyecto empresa BBDD\BBDD maestra.accdb; "
    'instruccion sql
    Dim cadena_sql As String = "UPDATE personal SET" ' Modificar datos
    cadena_sql = cadena_sql + " Nombre      = '" & nombre & "',"
    cadena_sql = cadena_sql + " Direccion   = '" & direccion & "',"
    cadena_sql = cadena_sql + " edad        = '" & xedad & "',"
    cadena_sql = cadena_sql + " telefono    = '" & telefono & "',"
    cadena_sql = cadena_sql + " sueldo_base = '" & xsueldo & "',"
    cadena_sql = cadena_sql + " Digito      = " & digito & ""
    cadena_sql = cadena_sql + " WHERE id    =" & xid
 
    'crear comando
    Dim comando As OleDbCommand = conexion.CreateCommand()
    comando.CommandText = cadena_sql
    'ejecutar consulta de accion
    conexion.Open()
    comando.ExecuteNonQuery()
    conexion.Close()
 
 
    Return True
End Function

Añade tu respuesta

Haz clic para o