how to delete value from database in grid view in window application c#

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();
}