[2005] delect and update statement in dataset

[newpat]

if I select the specific rows and want to delete, what is the code?
I have try the code

delect from table;

but it delete all of my rows

[jmcilhinney]

This is not a VB.NET question. SQL questions belong in the Database Development forum.

You need to use a WHERE clause to specify which records you want to delect (sic). If you want to delete a specific record by ID it would be:

DELETE FROM MyTable WHERE ID = @ID

If you want to delete all records from before a specific date it would be:

DELETE FROM MyTable WHERE [Date] < @Date

[newpat]

okay, next time I will post the sql question to Database Development forum
do the code add to the delete button?

[jmcilhinney]

What you posted and what I posted is SQL code, not VB code. If you want to execute SQL statements in VB then you use ADO.NET. If you want to do something when the user clicks a Button you handle its Click event. You need to create a Click event handler for your button and use ADO.NET to execute that SQL. Follow the Data Access link in my signature for some examples of using ADO.NET in VB.