datagrid中读取的行鼠标经过的时候,设置鼠标悬停行的颜色

来源:互联网 发布:美食知乎精华 编辑:程序博客网 时间:2024/05/21 19:48
 

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;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
  

        if (Session["userName"] != null)        //判断用户是否登录   
        {
            bindBookInfo();                     //调用自定义方法用来绑定图书借阅排行
        }
        else
            Response.Redirect("entry.aspx");    //跳转到登录页面
    }
    protected void bindBookInfo()
    {
        string sql = "select top 10 * from tb_bookInfo order by borrowSum desc";            //设置SQL语句
        gvBookTaxis.DataSource = dataOperate.getDataset(sql);    //获取图书信息数据源
        gvBookTaxis.DataBind();                                                 //绑定GridView控件
    }

    protected void gvBookTaxis_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex != -1)   //判断GridView控件中是否有值
        {
            int id = e.Row.RowIndex + 1;//将当前行的索引加上一赋值给变量id
            e.Row.Cells[0].Text = id.ToString();//将变量id的值传给GridView控件的每一行的单元格中
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //绑定图书类型
            string bookType = e.Row.Cells[3].Text.ToString();           //获取图书类型编号
            string typeSql = "select * from tb_bookType where TypeID=" + bookType;
            SqlDataReader typeSdr = dataOperate.getRow(typeSql);
            typeSdr.Read();                                             //读取一条数据
            e.Row.Cells[3].Text = typeSdr["typeName"].ToString();       //设置图书类型
            //绑定书架
            string bookcase = e.Row.Cells[4].Text.ToString();           //获取书架编号
            string caseSql = "select * from tb_bookcase where bookcaseID=" + bookcase;
            SqlDataReader caseSdr = dataOperate.getRow(caseSql);
            caseSdr.Read();
            e.Row.Cells[4].Text = caseSdr["bookcaseName"].ToString();   //设置书架
            //设置鼠标悬停行的颜色
            e.Row.Attributes.Add("onMouseOver", "Color=this.style.backgroundColor;this.style.backgroundColor='#DAE7FC'");
            e.Row.Attributes.Add("onMouseOut", "this.style.backgroundColor=Color;");
        }
    }
}
前台用一个datagriw设置一个读取数据库的数据,当经过时或者悬停时会有变化,代码最两行就是关键代码。具体效果图如下:

原创粉丝点击