博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
gridview分頁:第一頁 下一頁 1 2 3 4 上一頁 最末頁
阅读量:4561 次
发布时间:2019-06-08

本文共 5178 字,大约阅读时间需要 17 分钟。

效果圖:

功能簡介:可使用上下鍵選中行,選中後點擊修改,textbox獲得gridview中的代碼的數據。對你有幫助的話,請記得要點擊“好文要頂”哦!!!不懂的,請留言。廢話不多說了,貼碼如下:

View Code
     GridView分頁           
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient;//請添加以下命名空間 using System.Data; using System.Drawing; public partial class _Default : System.Web.UI.Page {
SqlConnection con = new SqlConnection("Server=SERVER\\xxx;Database=xxxx;User ID=xx;Pwd=xx;"); private int _i = 0;//定義變量 ,查詢 Grid設定樣式有用到 protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
getBind(); } } protected void getBind() {
string str = "select * from im01"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(str, con); da.Fill(ds); DataTable dt = ds.Tables[0]; gvData.DataSource = dt; gvData.DataBind(); } protected void gvData_PageIndexChanging(object sender, GridViewPageEventArgs e) {
} protected void gvData_RowCreated(object sender, GridViewRowEventArgs e) {
if (e.Row.RowType == DataControlRowType.Pager) {
Label label_Index = new Label(); LinkButton Button_IndexFirst = new LinkButton(); LinkButton Button_IndexLast = new LinkButton(); LinkButton Button_IndexNext = new LinkButton(); LinkButton Button_IndexPrevious = new LinkButton(); Button_IndexFirst.Text = "第一頁 "; Button_IndexFirst.CommandName = "first"; Button_IndexFirst.ForeColor = Color.Blue; Button_IndexFirst.Click += new EventHandler(PageButtonClick); Button_IndexNext.Text = " 下一頁 "; Button_IndexNext.CommandName = "next"; Button_IndexNext.ForeColor = Color.Blue; Button_IndexNext.Click += new EventHandler(PageButtonClick); Button_IndexPrevious.Text = "前一頁 "; Button_IndexPrevious.CommandName = "previous"; Button_IndexPrevious.ForeColor = Color.Blue; Button_IndexPrevious.Click += new EventHandler(PageButtonClick); Button_IndexLast.Text = "最末頁 "; Button_IndexLast.CommandName = "last"; Button_IndexLast.ForeColor = Color.Blue; Button_IndexLast.Click += new EventHandler(PageButtonClick); e.Row.Controls[0].Controls[0].Controls[0].Controls[0].Controls.AddAt(0, (Button_IndexFirst)); e.Row.Controls[0].Controls[0].Controls[0].Controls[0].Controls.AddAt(1, (Button_IndexPrevious)); int controlTmp = e.Row.Controls[0].Controls[0].Controls[0].Controls.Count - 1; e.Row.Controls[0].Controls[0].Controls[0].Controls[controlTmp].Controls.Add(Button_IndexNext); e.Row.Controls[0].Controls[0].Controls[0].Controls[controlTmp].Controls.Add(Button_IndexLast); } } protected void gvData_RowDataBound(object sender, GridViewRowEventArgs e) {
if (e.Row.RowType == DataControlRowType.DataRow) {
//设置悬浮鼠标指针形状为"小手" e.Row.Attributes["style"] = "Cursor:hand"; } string strGvName = "gvData"; e.Row.Attributes.Add("id", strGvName + _i.ToString()); e.Row.Attributes.Add("onKeyDown", "SelectRow(event,'" + strGvName + "');"); e.Row.Attributes.Add("onClick", "MarkRow(" + _i.ToString() + ",'" + strGvName + "');"); e.Row.Attributes.Add("tabindex", "0"); _i++; } protected void PageButtonClick(object sender, EventArgs e) {
LinkButton clickedButton = ((LinkButton)sender); if (clickedButton.CommandName == "first") {
gvData.PageIndex = 0; } else if (clickedButton.CommandName == "next") {
if (gvData.PageIndex < gvData.PageCount - 1) {
gvData.PageIndex += 1; } } else if (clickedButton.CommandName == "previous") {
if (gvData.PageIndex >= 1) {
gvData.PageIndex -= 1; } } else if (clickedButton.CommandName == "last") {
gvData.PageIndex = gvData.PageCount - 1; } getBind(); } //修改 protected void btnUpd_Click(object sender, EventArgs e) {
int intNum = 0; if (this.NUM.Text == "" || this.NUM.Text == "0") {
Response.Write(""); return; } else {
intNum = Convert.ToInt16(this.NUM.Text) - 1; tbValue.Text = this.gvData.Rows[intNum].Cells[1].Text.ToString(); } } }

转载于:https://www.cnblogs.com/koeltp/archive/2012/02/21/2361143.html

你可能感兴趣的文章
BZOJ2143 飞飞侠 & [校内NOIP2018模拟20181026] 最强大脑
查看>>
Linux/Mac 挂载远程服务器目录到本地
查看>>
1,实现在线答题 2,答题结束后可以判断对错 3,并将错题的结果保存起来。...
查看>>
JS中原始值和引用值的储存方式
查看>>
初学C#的简单编程题合集(更新)
查看>>
Linux学习闲谈(一)——Shell基本操作与命令
查看>>
写日志文件
查看>>
jvm 学习 二
查看>>
Date的格式转换
查看>>
RAC中SID,instance_number,thread#,undotbs之间的关系
查看>>
android注解-butterknife
查看>>
第二单元博客作业
查看>>
你可能不需要 jQuery!使用原生 JavaScript 进行开发
查看>>
java 继承、重载、重写与多态
查看>>
python的常用库及文档使用
查看>>
Linux 桌面系统关系
查看>>
iOS进阶_动画的多种实现方式
查看>>
【转】Python入门:Anaconda和Pycharm的安装和配置
查看>>
ArcGIS 中要素的查询与修改
查看>>
POJ1734【Floyd求最小环板子】
查看>>