Modify below code accordign to your requirement.
private void Bind()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Table Name", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void DeleteData()
{
string sql = "DELETE FROM Table Name WHERE [id] = '" + dataGridView2.Rows[i].Cells["[id]"].Value.ToString() + "' ";
SqlCommand cmd = new SqlCommand(sql, objConn1);
objConn1.Open();
cmd.ExecuteNonQuery();
objConn1.Close();
Bind();
}