Give Gridview cell font colour according to condition
Posted
by
vim
on Stack Overflow
See other posts from Stack Overflow
or by vim
Published on 2014-08-20T04:02:03Z
Indexed on
2014/08/20
4:21 UTC
Read the original article
Hit count: 183
How can I give colour to gridview's cell text according to condition. I have a below gridview and I am taking data in gridview by code behind.
<asp:GridView ID="GridView3" runat="server" AllowPaging="true" PageSize="5"
AutoGenerateColumns="false" Width="100%" OnPageIndexChanging="GridView3_PageIndexChanging"
CssClass="Grid">
<RowStyle CssClass="GridRow"/>
<Columns>
<asp:BoundField HeaderText="No" DataField="id" Visible="false"/>
<asp:BoundField HeaderText="Scenario" DataField="Scenario"/>
<asp:BoundField HeaderText="Type" DataField="Type"/>
<asp:BoundField HeaderText="Station Name" DataField="StationName"/>
<asp:BoundField HeaderText="Parameter" DataField="PARAM"/>
<asp:BoundField HeaderText="Value" DataField="Value"
SortExpression="Value" DataFormatString="{0:F2}"/>
</Columns>
<PagerStyle BackColor="White" Height="40px" Font-Bold="true" Font-
Size="Medium" ForeColor="Green" HorizontalAlign="Center"/>
<PagerSettings FirstPageText="First" LastPageText="Last"
Mode="NumericFirstLast" PageButtonCount="3" />
<HeaderStyle BackColor="#ABDB78" ForeColor="Black" Height="35px" Font-
Size="13px" Font-Names="verdana"/>
</asp:GridView>
I am binding data with this grid by code behind.
protected void ReservGridBind()
{
string name = Request.QueryString[1].ToString();
string query = "SELECT SD.id,SD.Scenario,SD.Value,PR.Type,PR.StationName,PR.PARAM
from sgwebdb.param_reference as PR Inner join sgwebdb.scenario_data as SD
ON PR.Param_Id=SD.Param_Id INNER JOIN sgwebdb.qualicision_detail as Q
ON SD.SCENARIO=Q.Alternative where PR.Type='Reservoirs' and Q.Alternative='" + name +"'";
this.GridView1.DataSource = PSI.DataAccess.Database.DatabaseManager
.GetConnection().GetData(query);
GridView1.DataBind();
condition :
if text < 0 then blue colour ,
text > 0 && text < 4 then green colour,
text > 4 then red colour.
Please help me for this gridview's cell text colour.
© Stack Overflow or respective owner