GridView突出显示某一单元格（例如金额低于多少，分数不及格等）

GridView突出显示某一单元格（例如金额低于多少，分数不及格等）

效果图：

解决方案：主要是绑定后过滤
GridView1.DataBind();
       for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{
            DataRowView mydrv =
myds.Tables["飞狐工作室"].DefaultView[i];
            string score =
Convert.ToString(mydrv["起薪"]);
            if (Convert.ToDouble(score) <
34297.00)//大家这里根据具体情况设置可能ToInt32等等
            {

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;

}
        }
        sqlcon.Close();

全部后台代码：

using System;
using System.Data;
using System.Configuration;
using
System.Web;
using System.Web.Security;
using System.Web.UI;
using
System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using
System.Drawing;

public partial class Default7 : System.Web.UI.Page
{
    SqlConnection
sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data
Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void
Page_Load(object sender, EventArgs e)
    {
        if
(!IsPostBack)
        {
            bind();

        }
    }
    protected void GridView1_RowEditing(object sender,
GridViewEditEventArgs e)
    {
        GridView1.EditIndex =
e.NewEditIndex;
        bind();
    }
    protected void
GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{
        sqlcon = new SqlConnection(strCon);
        string sqlstr =
"update 飞狐工作室 set 姓名='"
            +
((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()
+ "',家庭住址='"
            +
((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()
+ "' where 身份证号码='"
            +
GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom = new
SqlCommand(sqlstr, sqlcon);
        sqlcon.Open();

sqlcom.ExecuteNonQuery();
        sqlcon.Close();

GridView1.EditIndex = -1;
        bind();
    }
    protected void
GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{
        GridView1.EditIndex = -1;
        bind();
    }
    public
void bind()
    {
        string sqlstr = "select top 10 * from
飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter
myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new
DataSet();
        sqlcon.Open();
        myda.Fill(myds,
"飞狐工作室");
        GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "身份证号码" };

GridView1.DataBind();
       for (int i = 0; i <=
GridView1.Rows.Count - 1; i++)
        {
            DataRowView mydrv =
myds.Tables["飞狐工作室"].DefaultView[i];
            string score =
Convert.ToString(mydrv["起薪"]);
            if (Convert.ToDouble(score) <
34297.00)//大家这里根据具体情况设置可能ToInt32等等


{
                GridView1.Rows[i].Cells[4].BackColor =
System.Drawing.Color.Red;
            }
        }

sqlcon.Close();
    }
}

前台代码：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head
id="Head1" runat="server">
    <title>GridView突出显示某一单元格清清月儿http://blog.csdn.net/21aspnet
</title>
</head>
<body >
    <form id="form1"
runat="server">
    <div >
                   <asp:GridView
ID="GridView1" runat="server"    AutoGenerateColumns="False" CellPadding="3"
OnRowEditing="GridView1_RowEditing"

OnRowUpdating="GridView1_RowUpdating"
OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px"
>
                        <FooterStyle BackColor="White"
ForeColor="#000066" />

<Columns>
                            <asp:CommandField
HeaderText="编辑" ShowEditButton="True" />

<asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True"
/>
                            <asp:BoundField DataField="姓名"
HeaderText="姓名" />
                            <asp:BoundField
DataField="出生日期" HeaderText="邮政编码" />

<asp:BoundField DataField="起薪" HeaderText="起薪" DataFormatString="{0:C}"
HtmlEncode="false"/>
                            <asp:BoundField
DataField="家庭住址" HeaderText="家庭住址" />

<asp:BoundField DataField="邮政编码" HeaderText="邮政编码"
/>


</Columns>
                        <RowStyle ForeColor="#000066"
/>
                        <SelectedRowStyle BackColor="#669999"
Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left"
CssClass="ms-formlabel DataGridFixedHeader"/>

<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White"
/>
                    </asp:GridView>
        </div>