public void LlenarGridConsulta2() { DgvGeneral.Columns.Clear(); DgvGeneral.OptionsView.ColumnAutoWidth = false; DataViewManager dvm = new DataViewManager(dsConsulta2); DataView dvMain = dvm.CreateDataView(dsConsulta2.Tables[0]); DgvGeneral.OptionsBehavior.AutoPopulateColumns = false; GctrlGeneral.DataSource = dvMain; string[] captions = new[] { "CodArea", "Area", "CodMateria", "Materia", "Nota P1", "Porc. P1", "Nota P2", "Porc. P2", "Nota P3", "Porc. P3", "Nota P4", "Porc. P4", "Acumulado", "Fallas" }; GridColumn[] col = new GridColumn[dsConsulta2.Tables[0].Columns.Count]; for (int i = 0; i < dsConsulta2.Tables[0].Columns.Count; i++) { col[i] = DgvGeneral.Columns.AddField(dsConsulta2.Tables[0].Columns[i].Caption.Trim()); col[i].VisibleIndex = i; col[i].Caption = captions[i]; col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (i == 0 || i == 2) { col[i].Visible = false; } } DevExpress.XtraEditors.Repository.RepositoryItemTextEdit numerico = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); //numerico.ReadOnly = true; numerico.Mask.EditMask = "n0"; numerico.Mask.UseMaskAsDisplayFormat = true; numerico.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; DevExpress.XtraEditors.Repository.RepositoryItemTextEdit numerico1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); //numerico2.ReadOnly = true; numerico1.Mask.EditMask = "n1"; numerico1.Mask.UseMaskAsDisplayFormat = true; numerico1.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; DevExpress.XtraEditors.Repository.RepositoryItemTextEdit numerico2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); //numerico2.ReadOnly = true; numerico2.Mask.EditMask = "n"; numerico2.Mask.UseMaskAsDisplayFormat = true; numerico2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; DgvGeneral.Columns[4].ColumnEdit = numerico2; DgvGeneral.Columns[5].ColumnEdit = numerico2; DgvGeneral.Columns[6].ColumnEdit = numerico2; DgvGeneral.Columns[7].ColumnEdit = numerico2; DgvGeneral.Columns[8].ColumnEdit = numerico2; DgvGeneral.Columns[9].ColumnEdit = numerico2; DgvGeneral.Columns[10].ColumnEdit = numerico2; DgvGeneral.Columns[11].ColumnEdit = numerico2; DgvGeneral.Columns[12].ColumnEdit = numerico2; DgvGeneral.Columns[13].ColumnEdit = numerico; //DgvGeneral.Columns[0].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; Font fuenteNegrita = new Font("Tahoma", 8.25F, FontStyle.Bold); DgvGeneral.Columns[1].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[4].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[5].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[6].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[7].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[8].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[9].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[10].AppearanceCell.Font = fuenteNegrita; //DgvGeneral.Columns[11].AppearanceCell.Font = fuenteNegrita; DgvGeneral.Columns[12].AppearanceCell.Font = fuenteNegrita; DgvGeneral.Columns[13].AppearanceCell.Font = fuenteNegrita; DgvGeneral.Columns[4].AppearanceCell.BackColor = Color.FromArgb(0xFE, 0xF0, 0xE7); DgvGeneral.Columns[5].AppearanceCell.BackColor = Color.FromArgb(0xFC, 0xED, 0xE3); DgvGeneral.Columns[6].AppearanceCell.BackColor = Color.FromArgb(0xE2, 0xFA, 0xE7); DgvGeneral.Columns[7].AppearanceCell.BackColor = Color.FromArgb(0xDD, 0xF6, 0xE2); DgvGeneral.Columns[8].AppearanceCell.BackColor = Color.FromArgb(0xF9, 0xE3, 0xFA); DgvGeneral.Columns[9].AppearanceCell.BackColor = Color.FromArgb(0xF2, 0xDD, 0xF6); DgvGeneral.Columns[10].AppearanceCell.BackColor = Color.FromArgb(0xEA, 0xEA, 0xFD); DgvGeneral.Columns[11].AppearanceCell.BackColor = Color.FromArgb(0xE1, 0xE1, 0xFF); DgvGeneral.Columns[12].AppearanceCell.BackColor = Color.FromArgb(0xBF, 0xD4, 0xEF); DgvGeneral.Columns[13].AppearanceCell.BackColor = Color.FromArgb(0xF8, 0xC6, 0xC6); //DgvGeneral.Columns[10].AppearanceCell.BackColor = Color.FromArgb(0xCA, 0xE6, 0xCF); //DgvGeneral.Columns[11].AppearanceCell.BackColor = Color.FromArgb(0xCA, 0xE6, 0xCF); //DgvGeneral.Columns[12].AppearanceCell.BackColor = Color.FromArgb(0xCA, 0xE6, 0xCF); //DgvGeneral.Columns[13].AppearanceCell.BackColor = Color.FromArgb(0xCA, 0xE6, 0xCF); //DgvGeneral.Columns[14].AppearanceCell.BackColor = Color.FromArgb(0xCA, 0xE6, 0xCF); //DgvGeneral.Columns[15].AppearanceCell.BackColor = Color.FromArgb(0xE6, 0xBB, 0xBB); DgvGeneral.Columns[0].Width = 70; DgvGeneral.Columns[1].Width = 365; DgvGeneral.Columns[2].Width = 70; DgvGeneral.Columns[3].Width = 365; DgvGeneral.Columns[4].Width = 75; DgvGeneral.Columns[5].Width = 75; DgvGeneral.Columns[6].Width = 75; DgvGeneral.Columns[7].Width = 75; DgvGeneral.Columns[8].Width = 75; DgvGeneral.Columns[9].Width = 75; DgvGeneral.Columns[10].Width = 75; DgvGeneral.Columns[11].Width = 75; DgvGeneral.Columns[12].Width = 75; DgvGeneral.Columns[13].Width = 60; Funciones.getInstancia().Configurar_Grid(DgvGeneral); DgvGeneral.OptionsBehavior.Editable = false; DgvGeneral.OptionsCustomization.AllowSort = false; DgvGeneral.OptionsView.ColumnAutoWidth = false; DgvGeneral.OptionsCustomization.AllowGroup = true; DgvGeneral.OptionsView.ShowGroupPanel = false; DgvGeneral.Columns["NombreArea"].GroupIndex = 0; DgvGeneral.ExpandAllGroups(); }