【下载文档:  对GridView的行加颜色并弹出Kindeditor的实现思路.txt 】

---

对GridView的行加颜色并弹出Kindeditor的实现思路
前台代码: 复制代码 代码如下:

标题
内容
类别
用户

<%#eval_r("NewsTitle") %> 编辑 删除

第一页 上一页 下一页 最后一页

后台代码: 复制代码 代码如下: public partial class GridView : System.Web.UI.Page { string constr = "data source=.;initial catalog=News;user id=sa;password=111111;"; string sql = "select T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20) as NewsContent,T2.RealName,T1.CreateTime,T3.ClassName from (select ROW_NUMBER() over (order by Id) as rownumber,* from T_News) T1 left join T_User T2 on T1.NewsCreator=T2.UserId left join T_NewsClass T3 on T1.ClassId=T3.ClassId where rownumber>(@pageIndex-1)*@pageSize and rownumber<=@pageIndex*@pageSize"; int count; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ViewState["pageIndex"] = 1; DataPage(sql); } } private void DataPage(string sql) { SqlConnection conn = new SqlConnection(constr); conn.Open(); SqlCommand cmd = conn.CreateCommand(); // string sql = "select T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20) as NewsContent,T2.RealName ,T1.CreateTime,T3.ClassName from T_News1 T1 join T_User T2 on T1.NewsCreator=T2.UserId join T_NewsClass T3 on T1.ClassId=T3.ClassId"; cmd.Parameters.AddWithValue("@pageSize", 10); cmd.Parameters.AddWithValue("@pageIndex", Convert.ToInt32(ViewState["pageIndex"])); cmd.CommandText = sql; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); string sql1 = "select count(*) from T_News"; cmd.CommandText = sql1; int i =Convert.ToInt32(cmd.ExecuteScalar()); if (i % 10 == 0) { ViewState["pageCount"] = i / 10; } else { ViewState["pageCount"] = i / 10+1; } conn.Close(); conn.Dispose(); GridView1.DataSource = dt; GridView1.DataBind(); } protected void lbtnFirst_Click(object sender, EventArgs e) { ViewState["pageIndex"] = 1; DataPage(sql); } protected void lbtnProc_Click(object sender, EventArgs e) { int i=Convert.ToInt32(ViewState["pageIndex"]) ; if (i>1) { i--; ViewState["pageIndex"] = i; DataPage(sql); } } protected void lbtnNext_Click(object sender, EventArgs e) { int i = Convert.ToInt32(ViewState["pageIndex"]); if (i dic = new Dictionary(); dic.Add(e.SortExpression, "ASC"); ViewState["sortExp"] = dic; sql += " Order by " + e.SortExpression + " " + dic[e.SortExpression]; DataPage(sql); } else { //判断用户本次点击的排序字段是否和上次点击的排序字段一致，如果一致的话，那么就更改此字段的排序规则，如果不是就清除上次的排序字段，添加新的排序字段和规则(这是根据一个字段排序的情况) Dictionary dic = ViewState["sortExp"] as Dictionary; if (dic.ContainsKey(e.SortExpression)) { if (dic[e.SortExpression] == "ASC") { dic[e.SortExpression] = "DESC"; } else { dic[e.SortExpression] = "ASC"; } } else//如果不包含的话就生新创建一个 { //dic.Clear(); dic.Add(e.SortExpression, "ASC"); } sql +=" Order by "+ e.SortExpression + " " + dic[e.SortExpression]; DataPage(sql); } } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) { for (int i = 0; i < e.Row.Cells.Count; i++) { if (e.Row.Cells[i].Controls.Count > 0) { LinkButton link = e.Row.Cells[i].Controls[0] as LinkButton; string sortexp = link.CommandArgument; if (ViewState["sortExp"] != null) { Dictionary dic = ViewState["sortExp"] as Dictionary; if (dic.ContainsKey(sortexp)) { Literal li = new Literal(); if (dic[sortexp] == "ASC") { li.Text = "↑"; } else { li.Text = "↓"; } e.Row.Cells[i].Controls.Add(li); } } } } } //按条件给gridview的行加背景颜色 if (e.Row.RowType == DataControlRowType.DataRow) { if (e.Row.Cells[3].Text == "肖唯哲") { e.Row.BackColor = Color.Red; //根据条件统计当前页的记录数 count++; } } if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells.RemoveAt(6); e.Row.Cells.RemoveAt(5); e.Row.Cells.RemoveAt(4); e.Row.Cells.RemoveAt(3); e.Row.Cells.RemoveAt(2); e.Row.Cells.RemoveAt(1); e.Row.Cells[0].ColumnSpan = 8; e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right; e.Row.Cells[0].Text = string.Format("肖唯哲:{0}", count); } } protected void Button1_Click(object sender, EventArgs e) { string sqlid = string.Empty; foreach (GridViewRow row in this.GridView1.Rows) { CheckBox ck1=row.Cells[0].FindControl("ck1") as CheckBox; if (ck1.Checked == true) { LinkButton link=row.Cells[6].FindControl("linkbtnEdit") as LinkButton; sqlid +=" "+link.CommandArgument + " ,"; } } string sql1 = "delete from T_News where Id in (" + sqlid.TrimEnd(',')+")"; int i= DeleteDatas(sql1); if (i > 0) { ClientScript.RegisterStartupScript(this.GetType(), "key", "alert('删除成功!')", true); DataPage(sql); } } private int DeleteDatas(string sql1) { SqlConnection conn = new SqlConnection(constr); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sql1; int num = Convert.ToInt32(cmd.ExecuteNonQuery()); return num; conn.Dispose(); } protected void Button2_Click1(object sender, EventArgs e) { //Response.Write(""); ClientScript.RegisterStartupScript(this.GetType(), "key", "showdiv()", true); } }