private void FillUDS() { dt = new DataTable(); dt = UnitDirBL.GetBlockWiseUDS(m_iCCId); grdUDS.DataSource = dt; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToDecimal(dt.Rows[i]["WithHeld"]) == 0) { dt.Rows[i]["WithHeld"] = 100; } } } grdViewUDS.Columns["CostCentreId"].Visible = false; grdViewUDS.Columns["BlockId"].Visible = false; grdViewUDS.BestFitColumns(); grdViewUDS.Columns["BlockName"].OptionsColumn.ReadOnly = true; grdViewUDS.Columns["BlockName"].OptionsColumn.AllowEdit = false; RepositoryItemTextEdit txtLA = new RepositoryItemTextEdit(); grdViewUDS.Columns["LandArea"].ColumnEdit = txtLA; txtLA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtLA.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtLA.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; txtLA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtLA.Mask.UseMaskAsDisplayFormat = true; txtLA.EditValueChanged += txtLA_EditValueChanged; RepositoryItemTextEdit txtWH = new RepositoryItemTextEdit(); grdViewUDS.Columns["WithHeld"].ColumnEdit = txtWH; txtWH.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtWH.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtWH.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; txtWH.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtWH.Mask.UseMaskAsDisplayFormat = true; txtWH.EditValueChanged += txtWH_EditValueChanged; RepositoryItemTextEdit txtNLA = new RepositoryItemTextEdit(); grdViewUDS.Columns["NetLandArea"].ColumnEdit = txtNLA; txtNLA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtNLA.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtNLA.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; txtNLA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtNLA.Mask.UseMaskAsDisplayFormat = true; txtNLA.EditValueChanged += txtNLA_EditValueChanged; RepositoryItemTextEdit txtFSI = new RepositoryItemTextEdit(); grdViewUDS.Columns["FSIIndex"].ColumnEdit = txtFSI; txtFSI.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtFSI.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtFSI.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; txtFSI.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtFSI.Mask.UseMaskAsDisplayFormat = true; txtFSI.EditValueChanged += txtFSI_EditValueChanged; RepositoryItemTextEdit txtBA = new RepositoryItemTextEdit(); grdViewUDS.Columns["BuildArea"].ColumnEdit = txtBA; txtBA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtBA.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtBA.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; txtBA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtBA.Mask.UseMaskAsDisplayFormat = true; txtBA.EditValueChanged += txtBA_EditValueChanged; grdViewUDS.Columns["LandArea"].Caption = "Total LandArea"; grdViewUDS.Columns["WithHeld"].Caption = "WithHeld (%)"; grdViewUDS.OptionsCustomization.AllowFilter = false; grdViewUDS.OptionsView.ShowAutoFilterRow = false; grdViewUDS.OptionsView.ShowViewCaption = false; grdViewUDS.OptionsView.ShowFooter = false; grdViewUDS.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; grdViewUDS.OptionsSelection.InvertSelection = false; grdViewUDS.OptionsView.ColumnAutoWidth = true; grdViewUDS.Appearance.HeaderPanel.Font = new Font(grdViewUDS.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewUDS.Appearance.FocusedCell.BackColor = Color.Teal; grdViewUDS.Appearance.FocusedCell.ForeColor = Color.White; grdViewUDS.Appearance.FocusedRow.ForeColor = Color.Black; grdViewUDS.Appearance.FocusedRow.BackColor = Color.Teal; grdViewUDS.OptionsSelection.EnableAppearanceHideSelection = false; }