I am using visual studio 2005 to develop a form using c#
I have 3 datagrids on one form.
I can set the row color based on a certain value in a column. However this
color applies to all 3 datagrida. I would like to set it so that
if value of column 3 in datagrid 1 is < 100 set to red, if = 100 set to green
if value of column 3 in datagrid 2 is < 90 set to red, if >= 90 set to green
if value of column 3 in datagrid 3is < 80 set to red, if >= 80set to green
No matter how I write my code I cannot seem to get the coloring to apply to
just one datagrid
My code is below:
<%@ Page Language="C#" %>
<%@ Import Namespace="Syst em.Drawing" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<script runat="server">
protected void GridView1_Selec tedIndexChanged (object sender, EventArgs e)
{
}
protected void GridView1_RowDa taBound(object sender,
GridViewRowEven tArgs e)
{
if (e.Row.RowType == DataControlRowT ype.DataRow)
{
if (Decimal.Parse( e.Row.Cells[3].Text) < 100)
e.Row.Cells[3].BackColor = Color.IndianRed ;
else
e.Row.Cells[3].BackColor = Color.MediumSea Green;
}
}
protected void GridView3_RowDa taBound(object sender, GridViewRowEven tArgs e)
{
if (e.Row.RowType == DataControlRowT ype.DataRow)
{
if (Decimal.Parse( e.Row.Cells[3].Text) < 70)
e.Row.Cells[3].BackColor = Color.IndianRed ;
else
e.Row.Cells[3].BackColor = Color.MediumSea Green;
}
}
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void GridView2_Selec tedIndexChanged (object sender, EventArgs e)
{
}
</script>
<html><!-- InstanceBegin template="/Templates/supportstats.dw t"
codeOutsideHTML IsLocked="false " -->
<head>
<!-- InstanceBeginEd itable name="doctitle" -->
<title>HKS Medical Information Systems</title>
<!-- InstanceEndEdit able -->
<link rel="stylesheet " type="text/css" href="styles.cs s">
<script language="JavaS cript" src="common.js" type="text/JavaScript"></script>
<!-- InstanceBeginEd itable name="head" --><!-- InstanceEndEdit able --><!--
InstanceParam name="NavAboutU sON" type="boolean" value="false" --><!--
InstanceParam name="NavSoftwa reSolutionsON" type="boolean" value="false"
--><!-- InstanceParam name="NavServic esON" type="boolean" value="false"
--><!-- InstanceParam name="NavSuppor tON" type="boolean" value="false"
--><!-- InstanceParam name="NavNewsON " type="boolean" value="false" --><!--
InstanceParam name="NavContac tON" type="boolean" value="false" -->
<script language="JavaS cript">
function breadCrumbs(bas e,delStr,defp,c Style,tStyle,dS tyle,nl) { // by Paul
Davis - http://www.kaosweaver.com
loc=window.loca tion.toString() ;subs=loc.subst r(loc.indexOf(b ase)+base.lengt h+1).split("/");
document.write( '<a href="'+getLoc( subs.length-1)+defp+'"
class="'+cStyle +'">Home</a '+'<span class="'+dStyle +'">'+delStr+ '</span');
a=(loc.indexOf( defp)==-1)?1:2;for (i=0;i<(subs.le ngth-a);i++) {
subs[i]=makeCaps(unesc ape(subs[i]));
document.write( '<a href="'+getLoc( subs.length-i-2)+defp+'"
class="'+cStyle +'">'+subs[i]+'</a '+'<span
class="'+dStyle +'">'+delStr+ '</span');}
if (nl==1) document.write( "<br>");documen t.write('<span
class="'+tStyle +'">'+document. title+'</span>');
}
function makeCaps(a) {
g=a.split(' ');for (l=0;l<g.length ;l++)
g[l]=g[l].toUpperCase(). slice(0,1)+g[l].slice(1);
return g.join(" ");
}
function getLoc(c) {
var d="";if (c>0) for (k=0;k<c;k++) d=d+"../"; return d;
}
</script>
</head>
<body link="#6F96C6" alink="#6F96C6" vlink="#6F96C6" >
<table width="1000" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td width="224"><a href="http://www.hksys.com"> <img
src="images/hdr_logo.gif" alt="HKS Medical Information Systems" width="187"
height="79" border="0"></a></td>
<td width="776"><!-- InstanceBeginEd itable name="Header" --><img
src="images/hdr_home.jpg" alt="" height="79" style="width: 811px"><!--
InstanceEndEdit able --></td>
</tr>
</table>
<table width="1000" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td height="25" bgcolor="#6F96C 6"</td>
<td height="25" align="RIGHT" bgcolor="#6F96C 6"><table width="990"
height="23" border="0" cellpadding="0" cellspacing="0" >
<form action="search/search.pl" method="GET" name="SearchSit e">
<input type="hidden" name="p" value="1" /><input type="hidden"
name="lang" value="en" /><input type="hidden" name="include" value=""
/><input type="hidden" name="exclude" value="" /><input type="hidden"
name="penalty" value="0" /><input type="HIDDEN" name="mode" value="any">
</form>
</table></td>
</tr>
<tr>
<td height="8" colspan="2"><im g src="images/spacer.gif" width="1"
height="8"></td>
</tr>
</table>
<table width="996" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td width="1000" valign="TOP"><t able width="1000" border="0"
cellpadding="0" cellspacing="0" bgcolor="#A4A4A 5">
<tr>
<td height="1" colspan="3"><im g src="images/spacer.gif" width="1"
height="1"></td>
</tr>
<tr>
<td width="1000" bgcolor="#FFFFF F"><table width="100%" border="0"
cellpadding="0" cellspacing="0" >
<tr>
<td width="100%" bgcolor="#6F96C 6"><!-- InstanceBeginEd itable
name="PageTitle " --><span class="pageTitl e">Support SLA
Compliance </span><!-- InstanceEndEdit able --></td>
</tr>
<tr>
<td><table width="1000" border="0" cellpadding="0"
cellspacing="0" >
<tr>
<td width="1000"><!-- InstanceBeginEd itable
name="PageConte nt" -->
<form id="form1" runat="server">
<div>
<h1>
HKS Support Statistics</h1>
<p>
Click Links for more detail,
</p>
<p>
<span style="font-family: Arial">
<asp:HyperLin k ID="HyperLink1 " runat="server"
NavigateUrl="~/priority1-main.aspx">Prio rity 1 </asp:HyperLink>
Issues Last Updated:</span>
</p>
<p>
<asp:HyperLin k ID="HyperLink4 " runat="server"
NavigateUrl="~/priority1-graph.aspx"
Target="_blank" >Graph</asp:HyperLink</p>
<p>
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:SupportStats ConnectionStrin g %>"
SelectCommand=" SELECT Priority, Date,
Number_of_ticke ts_opened, Number_of_ticke ts_closed_withi n_24hrs,
ROUND([%_of_tickets_cl osed_within_sla s], 0) AS '% of Tickets Closed within
SLAS' FROM dbo.Priority1 WHERE (Date IN (SELECT MAX(Date) AS date FROM
dbo.Priority1 AS Priority1_1))
"></asp:SqlDataSour ce>
<asp:GridView ID="GridView1" runat="server"
OnRowDataBound= "GridView1_RowD ataBound" AutoGenerateCol umns="False"
CellPadding="4"
DataSourceID="S qlDataSource1" Font-Names="Arial"
ForeColor="#333 333" GridLines="None "
OnSelectedIndex Changed="GridVi ew1_SelectedInd exChanged" >
<FooterStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<RowStyle BackColor="#E3E AEB" HorizontalAlign ="Center"
Font-Bold="True" />
<EditRowStyle BackColor="#7C6 F57" />
<SelectedRowSty le BackColor="#C5B BAF" Font-Bold="True"
ForeColor="#333 333" />
<PagerStyle BackColor="#666 666" ForeColor="Whit e"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
<Columns>
<asp:BoundFie ld DataField="Date " HeaderText="Dat e"
ReadOnly="True" SortExpression= "Date" />
<asp:BoundFie ld DataField="Numb er_of_tickets_o pened"
HeaderText="# of Issues Opened"
SortExpression= "Number_of_tick ets_opened" />
<asp:BoundFie ld
DataField="Numb er_of_tickets_c losed_within_24 hrs" HeaderText="# of Issues
Resolved Within 24hrs"
SortExpression= "Number_of_tick ets_closed_with in_24hrs" />
<asp:BoundFie ld DataField="% of Tickets Closed within
SLAS" HeaderText="% of Issues Resolved Within SLAs"
SortExpression= "% of Tickets Closed within SLAS" />
</Columns>
</asp:GridView>
</p>
<p>
</p>
<p>
<span style="font-family: Arial">
<asp:HyperLin k ID="HyperLink2 " runat="server"
NavigateUrl="~/priority2-main.aspx">Prio rity 2</asp:HyperLinkIs sues Last
Updated:</span></p>
<p>
<span style="font-family: Arial"<asp:Hype rLink ID="HyperLink5 "
runat="server" NavigateUrl="~/priority2-graph.aspx"
Target="_blank" >Graph</asp:HyperLink>
<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:SupportStats ConnectionStrin g %>"
SelectCommand=" SELECT Priority, Date,
Number_of_ticke ts_opened, Number_of_ticke ts_closed_withi n_48hrs,
ROUND([%_of_tickets_cl osed_within_sla s], 0) AS '% of Tickets Closed within
SLAS' FROM dbo.Priority2 WHERE (Date IN (SELECT MAX(Date) AS date FROM
dbo.Priority2 AS Priority2_1))
"></asp:SqlDataSour ce>
<asp:GridView ID="GridView2" runat="server"
OnRowDataBound= "GridView1_RowD ataBound" AutoGenerateCol umns="False"
CellPadding="4"
DataSourceID="S qlDataSource2" ForeColor="#333 333"
GridLines="None " OnSelectedIndex Changed="GridVi ew2_SelectedInd exChanged">
<FooterStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<RowStyle BackColor="#E3E AEB" HorizontalAlign ="Center"
Font-Bold="True" />
<EditRowStyle BackColor="#7C6 F57" />
<SelectedRowSty le BackColor="#C5B BAF" Font-Bold="True"
ForeColor="#333 333" />
<PagerStyle BackColor="#666 666" ForeColor="Whit e"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
<Columns>
<asp:BoundFie ld DataField="Date " HeaderText="Dat e"
ReadOnly="True" SortExpression= "Date" />
<asp:BoundFie ld DataField="Numb er_of_tickets_o pened"
HeaderText="# of Issues Opened"
SortExpression= "Number_of_tick ets_opened" />
<asp:BoundFie ld
DataField="Numb er_of_tickets_c losed_within_48 hrs" HeaderText="# of Issues
Resolved Within 48hrs"
SortExpression= "Number_of_tick ets_closed_with in_48hrs" />
<asp:BoundFie ld DataField="% of Tickets Closed
within SLAS" HeaderText="% of Issues Resolved Within SLAS"
SortExpression= "% of Tickets Closed within SLAS"
/>
</Columns>
</asp:GridView>
</span>
</p>
<p>
</p>
<p>
<span style="font-family: Arial">
<asp:HyperLin k ID="HyperLink3 " runat="server"
NavigateUrl="~/priority3-main.aspx">Prio rity 3</asp:HyperLink>
Issues Last Updated:</span></p>
<p>
<span style="font-family: Arial">
<asp:HyperLin k ID="HyperLink6 " runat="server"
NavigateUrl="~/priority3-graph.aspx"
Target="_blank" >Graph</asp:HyperLink></span</p>
<p>
<span style="font-family: Arial">
<asp:SqlDataSou rce ID="SqlDataSour ce3" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:SupportStats ConnectionStrin g %>"
SelectCommand=" SELECT Priority, Date,
number_of_ticke ts_opened, number_of_ticke ts_closed_withi n_120hrs,
ROUND([%_of_tickets_cl osed_within_sla s], 0) AS '% of Tickets Closed within
SLAS' FROM dbo.Priority3 WHERE (Date IN (SELECT MAX(Date) AS date FROM
dbo.Priority3 AS Priority3_1))"> </asp:SqlDataSour ce>
<asp:GridView ID="GridView3" runat="server"
OnRowDataBound= "GridView1_RowD ataBound" AutoGenerateCol umns="False"
CellPadding="4"
DataSourceID="S qlDataSource3" ForeColor="#333 333"
GridLines="None ">
<FooterStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<RowStyle BackColor="#E3E AEB" HorizontalAlign ="Center"
Font-Bold="True" />
<EditRowStyle BackColor="#7C6 F57" />
<SelectedRowSty le BackColor="#C5B BAF" Font-Bold="True"
ForeColor="#333 333" />
<PagerStyle BackColor="#666 666" ForeColor="Whit e"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#1C5 E55" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
<Columns>
<asp:BoundFie ld DataField="Date " HeaderText="Dat e"
ReadOnly="True" SortExpression= "Date" />
<asp:BoundFie ld DataField="numb er_of_tickets_o pened"
HeaderText="# of Issues Opened"
SortExpression= "number_of_tick ets_opened" />
<asp:BoundFie ld
DataField="numb er_of_tickets_c losed_within_12 0hrs" HeaderText="# of Issues
Resolved Within 200hrs"
SortExpression= "number_of_tick ets_closed_with in_120hrs" />
<asp:BoundFie ld DataField="% of Tickets Closed
within SLAS" HeaderText="% of Issues Resolved Within SLAs"
SortExpression= "% of Tickets Closed within SLAS"
/>
</Columns>
</asp:GridView>
</span>
</p>
</div>
</form>
<!-- InstanceEndEdit able --></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="1"><img src="images/spacer.gif" width="1"
height="1"></td>
</tr>
<tr>
<td height="1" colspan="3"><im g src="images/spacer.gif" width="1"
height="1"></td>
</tr>
</table></td>
</tr>
</table>
<table width="1000" border="0" cellpadding="8" cellspacing="0" >
<tr>
<td width="1000" align="CENTER" class="footer"> © 2006 HKS Medical
Information
Systems | <a href="http://web1.hksys.com/sw/" target="_blank"
class="footerLi nk">User
Support</a| <a href="http://www.hksys.com/admin/" target="_blank"
class="footerLi nk">Client
Login</a| <a href="default.h tm" class="footerLi nk">Home</a></td>
</tr>
<tr>
<td bgcolor="#6F96C 6"><img src="images/spacer.gif" width="1" height="10"
alt=""></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
