HI!![]()
this is the code to delete a record
Code:
but this code that work on an other program (but in vb 10 and with Access)Code:Chiave = DirectCast(Bs.Current, DataRowView).Item("ID") MsgBox(Chiave) MsgBox("Sei sicuro di voler eliminare questo contatto? ", MsgBoxStyle.YesNo, "Attenzione!") If vbYes Then If Not Conn.State = ConnectionState.Open Then Conn.Open() sqL = "DELETE * FROM MiaTabella WHERE ID= " & Chiave Cmd = New SqlCeCommand(sqL, Conn) Cmd.ExecuteNonQuery() Da.Update(Ds, "MiaTabella") Ds.Reset() Da.Fill(Ds, "MiaTabella") Bs = New BindingSource(Ds, "MiaTabella") DatiDB() End If
doesn't work !!!!!
On Cmd.ExcuteNonQuery() give me this error
Mistake during parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = * ]
How Could I resolve it ?




Reply With Quote