Databases
StackOverflow2013
Postsdbo
PODataGridView Cell color change
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODataGridView Cell color change
    primarykey
    data
    text
    <p>I have a test program that builds a datatable (26 rows by 6 cols) as datasource for a DataGridView.<br> The datagrid can be edited by selecting cells, and entering values from one of 3 NumUpDown controls.<br> Each control has specific color. To preserve the information, I save the table in user settings.<br> I keep the color information for each cell in extra table cells.<br> Problem: When I display the datagrid it reads OK the values from the table, but the cell colors that are supposed to be programatically added based on the extra cells info, do not show.<br> (I can see in diagnostics that the cells get the correct colors, but it does not show in the datagrid.<br> Looks like the datagird has some color override (?).<br> Attached is the full working code.<br> See more info in the code.<br> Can anyone be kind to run this and find why the colors are not shown in the datagrid? Thanks.</p> <pre><code>using System; using System.Data; using System.Drawing; using System.Web.UI.WebControls; using System.Windows.Forms; //This is a test program to do the following: //1. Build an empty data table of 26 rows by 6 columns. //2. The Table is bind (as DataSource) to a DataGridView. //3. The DataGrid Colomns 0-3 can be filled with decimals by one of 3 NumericUpDown controls. //3. For each cell in cols 0-2 there is one in cols 3-5 that holds info which NumUpDn was used. //4. Each NumUpDn has specific color. The corresponding cells have the same backcolor. //5. When the program starts, it builds the table from the Settings, and displays the table in the datagrid. //6. The cells in cols 0-2 are supposed to get the colors ad indicated in cols 3-5, but they do not. //To run, make a WinForm with a datagrid 'fareGrid' and 3 NumUpDn controls with background colors. namespace DataGridViewTest { public partial class Form1 : Form { DataTable fareTable = new DataTable(); int rowIndex; int colIndex; public Form1() { InitializeComponent(); buildFareTable("fareTable"); // Load the table (if exists) if (Properties.Settings.Default.fareTable != null) fareTable = Properties.Settings.Default.fareTable; paintFareTableCells(fareTable); } //Build the initial data table of 26R X 6C //Columns 3-5 are used to hold the color information of cols 0-2 public void buildFareTable(string fareTableName) { fareTable.TableName = fareTableName; fareTable.Columns.Add("Weekday", typeof(Decimal)); fareTable.Columns.Add("HalfDay", typeof(Decimal)); fareTable.Columns.Add("Weekend", typeof(Decimal)); //Adding 3 indexing columns that will hold the tables cell group fareTable.Columns.Add("IWeekday", typeof(String)); fareTable.Columns.Add("IHalfDay", typeof(String)); fareTable.Columns.Add("Iweekend", typeof(String)); for (rowIndex = 0; rowIndex &lt; 26; rowIndex++) { fareTable.Rows.Add(); } } public void paintFareTableCells(DataTable fareTable) { fareDataGrid.DataSource = fareTable; for (rowIndex = 0; rowIndex &lt; 26; rowIndex++) { for (colIndex = 0; colIndex &lt; 3; colIndex++) { switch (fareTable.Rows[rowIndex][colIndex + 3].ToString()) //Check the color index columns 3-5 { case "low": fareDataGrid[colIndex, rowIndex].Style.BackColor = Color.Green; break; case "med": fareDataGrid[colIndex, rowIndex].Style.BackColor = Color.Yellow; break; case "high": fareDataGrid[colIndex, rowIndex].Style.BackColor = Color.Red; break; default: break; } // Diagnostics: Check cell's color. At this point, Colors are OK! Color color = fareDataGrid[colIndex, rowIndex].Style.BackColor; } } } //Update the cells by 3 NumUpDn controls. private void numericUpDownFareHigh_ValueChanged(object sender, EventArgs e) { editFareTableCells(sender); } private void numericUpDownFareMed_ValueChanged(object sender, EventArgs e) { editFareTableCells(sender); } private void numericUpDownFareLow_ValueChanged(object sender, EventArgs e) { editFareTableCells(sender); } public void editFareTableCells(Object sender) { foreach (DataGridViewCell cell in fareDataGrid.SelectedCells) { if (cell.ColumnIndex &lt; 3) { cell.Value = ((NumericUpDown)sender).Value; cell.Style.BackColor = ((NumericUpDown)sender).BackColor; fareDataGrid[cell.ColumnIndex + 3, cell.RowIndex].Value = ((NumericUpDown)sender).Tag; //Uses cols 3-5 to hold cost level info. } } } //Use settings to preserve the data private void Form1_FormClosing(object sender, FormClosingEventArgs e) { Properties.Settings.Default.fareTable = this.fareTable; Properties.Settings.Default.Save(); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsamtal
    1. USsamtal
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODataGridView Cell color change
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODataGridView Cell color change
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PODataGridView Cell color change
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload