The easiest way to configure DataGridView for inserting and deleting data into a sql datat source is to use DataGridView smart tag, choosing the sql data source and check Enable adding and Enable deleting, the insert, delete and update commands of TableAdapter would be formed automatically or you can write your own commands and configure TableAdapter by yourself. After that simply use TableAdapter.Update() and TableAdapter.Fill()