GridView控件自定义分页详解.doc

GridView控件自定义分页详解在这里我们将用一个隐藏字段来保存这个PageIndex,即当前页码.当点击上一页时,将它的值减一,知道为0,要注意的一点这里的第一页页码是0而不是1.下面看看代码,然后我们再分析分析!12 3 4 6 7 9 10 11 12 13 首 页14 上一页15 下一页16 尾 页17 CS文件中的代码:1 protected void PagerButton_Click(object sender, EventArgs e)2 3 int pageIndx = Convert.ToInt32(CurrentPage.Value);4 int totals = NewsManager.GetNews(0, pageSize).TotalRecords;5 int pages = (totals % pageSize) = 0 ? (totals / pageSize) : (totals / pageSize + 1);6 string arg = (LinkButton)sender).CommandArgument.ToString().ToLower();7 switch (arg)8 9 case prev:10 if (pageIndx 0)11 12 pageIndx -= 1;13 14 break;15 case next:16 if (pageIndx pages - 1)17 18 pageIndx += 1;19 20 break;21 case last:22 pageIndx = pages - 1;23 break;24 default:25 pageIndx = 0;26 break;27 28 CurrentPage.Value = pageIndx.ToString();29 NewsGrid.DataSource = NewsManager.GetNews(pageIndx , pageSize).Entities;30 NewsGrid.DataBind();31 如何在GridView中增加效果protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /将满足特定条件的行标为高亮 if (e.Row.RowType = DataControlRowType.DataRow)/判定当前的行是否属于datarow类型的行 int money = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, MONEY);/取当前行的列值 if (money = 77) e.Row.BackColor = Color.Red; /string customer = (string)DataBinder.Eval(e.Row.DataItem, CUSTOMER); string customer = DataBinder.Eval(e.Row.DataItem, CUSTOMER).ToString(); if (customer = sdf) e.Row.BackColor = Color.Red; /加入鼠标滑过的高亮效果 if (e.Row.RowType = DataControlRowType.DataRow)/判定当前的行是否属于datarow类型的行 /当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色 e.Row.Attributes.Add(onmouseover, currentcolor=this.style.backgroundColor;this.style.backgroundColor=yellow,this.style.fontWeight=;); /当鼠标离开的时候 将背景颜色还原的以前的颜色 e.Row.Attributes.Add(onmouseout, this.style.backgroundColor=currentcolor,this.style.fontWeight=;); /单击行改变行背景颜色 if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onclick,this.style.backgroundColor=#99cc00; this.style.color=buttontext;this.style.cursor=default;); 如何在GridView中一次性批量更新多行数据ASP.NET2.0下含有DropDownList的GridView编辑、删除的完整例子！ %-asp:TextBox ID=TextBox1 runat=server Text=-% asp:DropDownList ID =ddlXL runat=server DataValueField= asp:Label ID=Label1 runat=server Text= asp:TextBox ID=TextBox2 runat=server Text= asp:Label ID=Label2 runat=server Text= / / 绑定数据到GridView / private void GridViewBind() 检索数据库 string strSql = SELECT * FROM DB1; 得到数据集 this.GridView1.DataSource=conn.GetDs(strSql).Tables0.DefaultView; this.GridView1.DataBind(); / / 编辑当前行 / / / protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) GridView1.EditIndex = e.NewEditIndex; /当前编辑行背景色高亮 this.GridView1.EditRowStyle.BackColor = Color.FromName(#F7CE90); GridViewBind(); / / 取消编辑状态 / / / protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) GridView1.EditIndex = -1; GridViewBind(); / / 删除记录过程 / / / protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) /得到单位编号 string rowToDelete = GridView1.DataKeyse.RowIndex.Values0.ToString(); /转换为整数 /int ID=Convert.ToInt32(rowToDelete); /从数据库中删除 string str = DELETE FROM DB1 where DB1_1= + + rowToDelete + + ; try conn.RunSql(str); /重新绑定数据 GridViewBind(); catch (Exception ex) Response.Write(数据库错误，错误原因： + ex.Message); Response.End(); / / 更新记录过程 / / / protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) string ID = GridView1.DataKeyse.RowIndex.Values0.ToString(); string DB1_1 = (TextBox)GridView1.Rowse.RowIndex.FindControl(TextBox1).Text; /string DB1_2 = (TextBox)GridView1.Rowse.RowIndex.FindControl(TextBox2).Text; string DB1_2 = (DropDownList)GridView1.Rowse.RowIndex.FindControl(ddlXL).SelectedItem.Text; /判断表单项是否有空并给出提示信息 if (DB1_1 = | DB1_2 = ) conn.Alert(请输入完整信息！, Page); return; try conn.BuilderEdit(select * from DB1 where DB1_1 = + ID + ); conn.drDB1_1 = DB1_1; conn.drDB1_2 = DB1_2; conn.BuilderEditClose(); catch (OracleException err) if (err.Code.ToString() = 1) conn.Alert(错误：已存在具有相同主键的记录, Page); else conn.Alert(错误：未能添加记录, Page); Response.Write(alert(数据已被保存!);); /返回浏览状态 GridView1.EditIndex = -1; GridViewBind(); / / 分页事件 / / / protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) GridView1.PageIndex = e.NewPageIndex; GridViewBind(); / / 加入鼠标效果及为DropDownList绑定值 / / / protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /为DropDownList绑定值 if (DropDownList)e.Row.FindControl(ddlXL) != null) DropDownList ddlXL = (DropDownList)e.Row.FindControl(ddlXL); ddlXL.Items.Clear(); ddlXL.Items.Add(new ListItem(博士, 1); ddlXL.Items.Add(new ListItem(硕士, 2); ddlXL.Items.Add(new ListItem(学士, 3); /加入鼠标滑过的高亮效果 if (e.Row.RowType = DataControlRowType.DataRow)/判定当前的行是否属于datarow类型的行 /当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色 e.Row.Attributes.Add(onmouseover, currentcolor=this.style.backgroundColor;this.style.backgroundColor=yellow,this.style.fontWeight=;); /当鼠标离开的时候 将背景颜色还原的以前的颜色 e.Row.Attributes.Add(onmouseout, this.style.backgroundColor=currentcolor,this.style.fontWeight=;); /单击行改变行背景颜色 if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onclick, this.style.backgroundColor=#99cc00; this.style.color=buttontext;this.style.cursor=default;); ASP.NET2.0下含有CheckBox的GridView删除选定记录实例4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 1 2 1 protected void btnDelete_Click(object sender, EventArgs e)2 3 string strDelete = ;4 for (int i = 0; i this.GridView1.Rows.Count; i+)5 6 string Label;7 bool isChecked = (CheckBox)GridView1.Rowsi.FindControl(chkSelect).Checked;8 Label = (Label)GridView1.Rowsi.FindControl(labXH).Text;9 if (isChecked)10 11 strDelete = DB1_1 + = + Label;12 13 14 conn.RunSql(Delete from DB1 where + strDelete 15 this.chkSelectA