Gridview实现突出显示某一单元格的方法

最新推荐文章于 2022-04-01 13:30:12 发布

weixin_30482181

最新推荐文章于 2022-04-01 13:30:12 发布

阅读量117

点赞数

文章标签： xhtml ui 数据库

原文链接：http://www.cnblogs.com/shangshen/p/3592209.html

版权

- 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突出显示某一单元格</titltle>
  </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>
  
      </form>
  </body>
  </html>

转载于:https://www.cnblogs.com/shangshen/p/3592209.html

weixin_30482181

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Gridview实现突出显示某一单元格的方法

GridView突出显示某一单元格（例如金额低于多少，分数不及格等）效果图：解决方案：主要是绑定后过滤GridView1.DataBind(); for (int i = 0; i <= GridView1.Rows.Count - 1; i++) { DataRowView m...
复制链接

扫一扫