How do I change cell color in DataGrid Web Form ?

Hello.
Goal: change datagrid cell forecolor/backcolor depending on cell value.

After some browsing I found plenty answers that simply don't fit class structure that VS2003 gives to a C# code. DataGrid is instantiated over VS 2003 IDE, graphically. Datagrid uses TableStyles and DataGridColumnStyles defined over IDE to give it some decent shaping.

I bind datagrid to a SQL table by this:
..
                  da=new SqlDataAdapter("select * from CTRX_CS",conn);
                  ds=new DataSet();
                              
                  da.Fill(ds);
                  ds.Tables[0].TableName="CTRX_CS";
                  dataGrid1.DataMember = "CTRX_CS";
                  dataGrid1.DataSource = ds;
...

BUT, I can't find any:

- DataGrid cell reference that would include .Foreground. There is one connected to datagrid object
  itself, but is ment 1 for entire datagrid, is it ?

- a friend told me I can use Paint event to alter currentcell. But If I reference for example
  DataGrid1[r][c] there is no .Foreground property. There's only ToString() and a few other properties that don't seem to fit into any color property.

So what to do ?

Thanks.
Grega




Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:

...
			da=new SqlDataAdapter("select * from CTRX_CS",conn);
			ds=new DataSet();
					
			da.Fill(ds);
			ds.Tables[0].TableName="CTRX_CS";
			dataGrid1.DataMember = "CTRX_CS";
			dataGrid1.DataSource = ds;
...
 
private void dataGrid1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
{
  int r=dataGrid1.CurrentRowIndex;
  int c=dataGrid1.CurrentCell.ColumnNumber;
 
  // only 1st row is interesting for this
  if (dataGrid1.CurrentCell.ColumnNumber==0) 
  {
       switch( ds.Tables[0].Rows[dataGrid1.CurrentRowIndex]["TIP"].ToString() ) 
       {
	case "SHOP":
	// now what ? I want current cell forecolor red..
         break;
	case "BAR":
         // color cell blue
	break;
	case "TEST":
         // color cell green
	break;
								
        }
  }
}