Cells conditional formatting (i.e.Red for negative values)

[Saverio Tedeschi]

Hi all gurus,
I'd like to have a "Excel like" behaviour, like that of the subj. Is it
possible? I guess not, since I've found no similar solution. However, trying
in "DataBinding" or "PreRender" methods? Any clue much appreciated. Thanks
in advance.

 

[Elton Wang]

Try

e.Item.Cells[col_index].BackColor
e.Item.Cells[col_index].ForeColor
e.Item.BackColor
e.Item.ForeColor

in DataGrid_ItemDataBound event

HTH

 

[Saverio Tedeschi]

Works like a charm. Lot of thanks.

Try

e.Item.Cells[col_index].BackColor
e.Item.Cells[col_index].ForeColor
e.Item.BackColor
e.Item.ForeColor

in DataGrid_ItemDataBound event

HTH

Hi all gurus,
I'd like to have a "Excel like" behaviour, like that of the subj. Is it
possible? I guess not, since I've found no similar solution. However,
trying in "DataBinding" or "PreRender" methods? Any clue much
appreciated. Thanks in advance.

 

[mkhmer]

Hi, I got more related question on this too...

How can I track the first row in data grid?
I used this method to add "Click event" on each row....but you know? the
result is that even the Header Row (top row with field name) also effected
with that click event.

I want to exclude that Header Row from being added with "Click" event.

Code Here:
===============
e.Item.Attributes.Add("onclick", "javascript:WinObj=window.open(......))
===============

Please help.
Thanks,

Try

e.Item.Cells[col_index].BackColor
e.Item.Cells[col_index].ForeColor
e.Item.BackColor
e.Item.ForeColor

in DataGrid_ItemDataBound event

HTH

Hi all gurus,
I'd like to have a "Excel like" behaviour, like that of the subj. Is it
possible? I guess not, since I've found no similar solution. However,
trying in "DataBinding" or "PreRender" methods? Any clue much
appreciated. Thanks in advance.

 

[Elton Wang]

Using following condition in datagrid_ItemCreated or datagrid_ItemDataBound
event:

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem )
{
e.Item.Attributes.Add( ...
}

HTH

Hi, I got more related question on this too...

How can I track the first row in data grid?
I used this method to add "Click event" on each row....but you know? the
result is that even the Header Row (top row with field name) also effected
with that click event.

I want to exclude that Header Row from being added with "Click" event.

Code Here:
===============
e.Item.Attributes.Add("onclick", "javascript:WinObj=window.open(......))
===============

Please help.
Thanks,

Try

e.Item.Cells[col_index].BackColor
e.Item.Cells[col_index].ForeColor
e.Item.BackColor
e.Item.ForeColor

in DataGrid_ItemDataBound event

HTH

Hi all gurus,
I'd like to have a "Excel like" behaviour, like that of the subj. Is it
possible? I guess not, since I've found no similar solution. However,
trying in "DataBinding" or "PreRender" methods? Any clue much
appreciated. Thanks in advance.

 

[mkhmer]

Wow....Great Thank for that...it work fine.

I got another issue now that the color format between IE and Netscap
browser....if you can help check it out for me:

e.Item.Attributes.Add("onmouseover" ,
"this.style.color='white';this.style.backgroundColor='gray';this.style.cursor='arrow';")
e.Item.Attributes.Add("onmouseout" ,
"this.style.color='black';this.style.backgroundColor='white';")

Netscap doesn't set my item color back into "black" and background into
"white" when I move out the move from eath item....but it work well in
IE....

Regards,