protected void showGd()
 {
     DsPSMS.ST_EQUIPMENT_DATADataTable equipDt = new DsPSMS.ST_EQUIPMENT_DATADataTable();
     //binding Equipment data to datagridview
     equipDt = equipService.getAllEquipData(out msg);
     if (equipDt != null && equipDt.Rows.Count != 0)
     {
         equipDt.Columns.Remove(equipDt.Columns[7]);
         equipDt.Columns.Remove(equipDt.Columns[7]);
         equipDt.Columns.Remove(equipDt.Columns[7]);
         equipDt.Columns.Remove(equipDt.Columns[7]);
         equipDt.Columns.Remove(equipDt.Columns[7]);
         EqpList.DataSource = equipDt;
         EqpList.DataBind();
     }
     // EqpList.Columns.[1].Visible = false;
 }
        protected void Delete_Click(object sender, EventArgs e)
        {
            DsPSMS.ST_EQUIPMENT_DATARow equipDr = new DsPSMS.ST_EQUIPMENT_DATADataTable().NewST_EQUIPMENT_DATARow();
            if (EqpList.SelectedIndex < 0)
            {
                errgrid.Text = "Please select the record that you want to delete";
            }
            else
            {
                equipDr.ID = Convert.ToInt32(EqpList.SelectedRow.Cells[1].Text);
                //to write for confirm message
                equipService.removeEquipmentData(equipDr, out msg);
                DataTable ds = new DataTable();
                ds = null;
                EqpList.DataSource = ds;
                EqpList.DataBind();

                showGd();
            }
        }