Grideview C# Insert Update Delete and View data from database in .net

Insert Update Delete and View data from database in .net C# 

How to delete data in database sql server

DELETE FROM Client

WHERE Name='Dovi' AND Clientname='Mmoi';

All Data Delete:

DELETE FROM Client;