how to delete or edit a tuples via vb.net

[Aberto]

Hello,
I have an application that allows me to see the database (the tables and records of each table)
I'm stuck on doing what I want: that when a select tuples is for example the table clients if this line is selected and click on the button to remove this client will be deleted from the table.
and for such a change but to do so I have no idea how?
what are the codes?
a big big thank you

[kelfro]

hi,
DELETE FROM `MyTable` WHERE `ID` = xxx

[Aberto]

I have 4 fields in the customer table so if introduced one of them (the name, surname, city) the tuple will be deleted from the table, but I try I can not find the answer.

[opaper]

hi,

you want to delete the records that match either name, first name or ID in the city?try the following method:


DELETE FROM `MyTable` WHERE `ID` = xxx Or `Name` = 'yyyy' Or `First` = 'zzzz' OR `City` = 'wwww'