CellFormatting Event - When Column is NOT Visible?

[eb24]

I am using C# 2.0 in a Windows Forms platform - I am using the CellFormatting() Event to display certain rows of my DataGridView with a certain color depending on the value found in a certain column. This works great if the Column is Visible, but I don't want to display this Column to the end users! Is there a way to do this?

This column has a Security flag that basically says Access or No Access and depending on these two values, it colors the Rows accordingly.

Thanks for any advice!

 

[ZmrAbdulla]

Try setting the Visible=true and width=0 of the coulmn.

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[eb24]

Zameer:

Thanks for responding but I've tried that already and having the .Width = 0, one can still see the column with a very small width. By having the Width = 0, as the user tabs through the cells, the Tab Stops within this small column, which I do not want.

Any other suggestions anyone?

 

[ZmrAbdulla]

This is working for me

this.DataGridView1.Columns(2).Visible == false

{ 
    int x; 
    for (x = 0; x <= this.DataGridView1.Rows.Count - 1; x++) { 
        if (this.DataGridView1.Rows(x).Cells(2).Value == 3) { 
            this.DataGridView1.Rows(x).DefaultCellStyle.BackColor = Color.Red; 
        } 
    } 
}

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[eb24]

Where do you have that second piece of code? Within a _CellFormatting Event?

FYI, I have the following and does not work:

private void dgv_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
  if (this.dgv.Columns[e.ColumnIndex].Name == "SecType")
  {
    if (e.Value.ToString() == "Access"))
    {
      dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red;
    }
  }
}

 

[ZmrAbdulla]

I have nothing other than loop through the rows.

________________________________________________________
Zameer Abdulla
Help to find Missing people