private void FillUDS() { DataSet ds = new DataSet(); DataView dv; DataRow[] drT; ds = UnitDirBL.GetBlockWiseUDSReport(m_iCCId); DataTable dt = new DataTable(); DataTable dtF = new DataTable(); dt = ds.Tables["NetLandArea"]; dtF = ds.Tables["FlatUDS"]; dt.Columns.Add("FlatUDS", typeof(decimal)); dt.Columns.Add("FlatBuildArea", typeof(decimal)); int iBlockId = 0; decimal dFlatUDS = 0; decimal dFlatBuildArea = 0; for (int i = 0; i < dt.Rows.Count; i++) { iBlockId = Convert.ToInt32(dt.Rows[i]["BlockId"]); dv = new DataView(dtF); dv.RowFilter = "BlockId=" + iBlockId + ""; if (dv.ToTable().Rows.Count > 0) { dFlatUDS = Convert.ToDecimal(dv.ToTable().Rows[0]["FlatUDS"]); dFlatBuildArea = Convert.ToDecimal(dv.ToTable().Rows[0]["FlatBuildArea"]); } else { dFlatUDS = 0; dFlatBuildArea = 0; } drT = dt.Select("BlockId = " + iBlockId + " "); if (drT.Length > 0) { drT[0]["FlatUDS"] = dFlatUDS; drT[0]["FlatBuildArea"] = dFlatBuildArea; } } grdUDS.DataSource = dt; 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 txtTA = new RepositoryItemTextEdit(); grdViewUDS.Columns["NetLandArea"].ColumnEdit = txtTA; txtTA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtTA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtTA.Mask.UseMaskAsDisplayFormat = true; RepositoryItemTextEdit txtNA = new RepositoryItemTextEdit(); grdViewUDS.Columns["FlatUDS"].ColumnEdit = txtNA; txtNA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtNA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtNA.Mask.UseMaskAsDisplayFormat = true; RepositoryItemTextEdit txtBA = new RepositoryItemTextEdit(); grdViewUDS.Columns["FlatBuildArea"].ColumnEdit = txtBA; txtBA.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtBA.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtBA.Mask.UseMaskAsDisplayFormat = true; 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; }