private void btnRemoveAddress_Click(object sender, EventArgs e)
 {
     if (dgvAddress.SelectedRows.Count < 1)
     {
         MessageBox.Show("Please Select an item to remove");
     }
     else
     {
         DialogResult dr = new DialogResult();
         dr = MessageBox.Show("Are you sure you want to delete this address?", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (dr == DialogResult.Yes)
         {
             CAddress address   = new CAddress();
             int      iRowIndex = dgvAddress.SelectedCells[0].RowIndex;
             int      IsValid   = address.RemoveAddress(conn, int.Parse(dgvAddress.Rows[iRowIndex].Cells[0].Value.ToString()));
         }
         RefreshDataSource(dgvAddress, "sp_GetAddressInfo");
     }
 }