gridview用ViewState做分页

最新推荐文章于 2013-06-13 14:08:00 发布
最新推荐文章于 2013-06-13 14:08:00 发布
阅读量795 收藏
点赞数
分类专栏： html asp.net 文章标签： textbox asp object server exception email
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/billyswang/article/details/8020361
版权

前台：

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%" DataKeyNames="ItemId" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" GridLines="None"CellSpacing="2"OnRowDeleting="GridView1_RowDeleting"OnRowUpdating="GridView1_RowUpdating">

        <Columns>

            <asp:TemplateField HeaderText="部门标志">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox2"runat="server"Text='<%#Eval("ImageUrl") %>'></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:Image ID="Image1" runat="server"ImageUrl='<%#"~/Upfile/" + Eval("ImageUrl") %>' Width="30" Height="28"/>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:BoundField DataField="ExhibitName" HeaderText="部门名称" />

            <asp:BoundField DataField="Linkman" HeaderText="联系人" />

            <asp:TemplateField HeaderText="项目经验" ShowHeader="False">

                <ItemStyle BorderWidth="0px"Wrap="False"/>

                <ItemTemplate>

                <asp:LinkButton ID="LinkButton2"runat="server"CausesValidation="false"CommandName="Select"

                   Text='<%#DataBinder.Eval(Container,"DataItem.ProjectExperience").ToString().Length > 10 ?DataBinder.Eval(Container, "DataItem.ProjectExperience").ToString().Substring(0,10) + "..." : DataBinder.Eval(Container,"DataItem.ProjectExperience")%>'></asp:LinkButton>

               

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="删除">

                <EditItemTemplate>

                    <asp:TextBox ID="TextBox1"runat="server"></asp:TextBox>

                </EditItemTemplate>

                <ItemTemplate>

                    <asp:ImageButton ID="imgDelete"runat="server"  CommandName="Delete" ImageUrl="~/images/delete.gif" OnClientClick="returnconfirm('你确定删除吗?')" style="cursor:hand;"/>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:ButtonField ButtonType="Image" CommandName="Update"

                            HeaderText="修改" ImageUrl="~/images/edit.gif">

                            <ItemStyle Width="25px"/>

                <HeaderStyle Wrap="False"/>

                        </asp:ButtonField>

        </Columns>

        <RowStyle Font-Size="13px" HorizontalAlign="Center" />

        <HeaderStyle Font-Size="14px" HorizontalAlign="Center" />

    </asp:GridView>

    <table width="100%">

        <tr id="pagerTr" runat="server">

            <td align="right" style="font-size: 12px; height: 28px">

                &nbsp;<asp:Label ID="labTotal"runat="server"Text="共0条记录 第0页/共0页"></asp:Label>

                &nbsp;<asp:LinkButton ID="linkFirst"runat="server"OnClick="linkFirst_Click">首页</asp:LinkButton>

                &nbsp;<asp:LinkButton ID="linkPrevious"runat="server"OnClick="linkPrevious_Click">上一页</asp:LinkButton>

                &nbsp;<asp:LinkButton ID="linkNext"runat="server"OnClick="linkNext_Click">下一页</asp:LinkButton>

                &nbsp;<asp:LinkButton ID="linkLast"runat="server"OnClick="linkLast_Click">尾页</asp:LinkButton>

                &nbsp;

                <asp:TextBox ID="txtRows" runat="server" Width="20px"></asp:TextBox>

                &nbsp;

                <asp:LinkButton ID="linkGO" runat="server" CausesValidation="False" OnClick="linkGO_Click">GO</asp:LinkButton>

                &nbsp;</td>

        </tr>

</table>

 

 

后台：

#region Private Members

 VenuesControllervc = new VenuesController();//封转的数据逻辑业务

 introwcount = 10; //要显示的行数

#endregion

protected void Page_Load(System.Object sender, System.EventArgse)

        {

            try

            {

                if (!Page.IsPostBack)

                {

                    panAdd.Visible =false;

                    panList.Visible= false;

                    Label1.Visible =false;

 

                    ViewState[this.ID + "startPage"]= 1;

                    ViewState[this.ID + "totalPage"]= 0;

 

                    Binder();

                }

            }

            catch(Exception exc) //Modulefailed to load

            {

                Exceptions.ProcessModuleLoadException(this, exc);

            }

 

        }

 

        ///<summary>

        ///首页

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid linkFirst_Click(objectsender, EventArgs e)

        {

            ViewState[this.ID + "startPage"]= 1;

            Binder();

        }

 

        ///<summary>

        ///上一页

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid linkPrevious_Click(object sender, EventArgs e)

        {

            intstartPage = int.Parse(ViewState[this.ID + "startPage"].ToString());

            startPage = startPage -1;

            startPage = startPage< 1 ? 1 : startPage;

            ViewState[this.ID + "startPage"]= startPage;

            Binder();

        }

 

        ///<summary>

        ///下一页

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid linkNext_Click(objectsender, EventArgs e)

        {

            intstartPage = int.Parse(ViewState[this.ID + "startPage"].ToString());

            inttotalPage = int.Parse(ViewState[this.ID + "totalPage"].ToString());

            startPage = startPage +1;

            startPage = startPage> totalPage ? totalPage : startPage;

            ViewState[this.ID + "startPage"]= startPage;

            Binder();

        }

 

        ///<summary>

        ///尾页

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid linkLast_Click(objectsender, EventArgs e)

        {

            ViewState[this.ID + "startPage"]= ViewState[this.ID + "totalPage"];

            Binder();

        }

 

        ///<summary>

        ///跳转到指定页

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid linkGO_Click(objectsender, EventArgs e)

        {

            intcurPage = 0;

            try

            {

                curPage = int.Parse(this.txtRows.Text.Trim());

            }

            catch

            {

                this.txtRows.Text = "";

               Page.ClientScript.RegisterStartupScript(this.GetType(),"prompt", "alert('输入的页码不正确，请重新输入!')", true);

                return;

            }

 

            inttotalPage = int.Parse(ViewState[this.ID + "totalPage"].ToString());

            curPage = curPage >totalPage ? totalPage : curPage;

            curPage = curPage < 1? 1 : curPage;

            ViewState[this.ID + "startPage"]= curPage;

            Binder();

        }

 

        ///<summary>

        ///数据绑定

        ///</summary>

        publicvoid Binder()

        {

            intstart = (int.Parse(ViewState[this.ID + "startPage"].ToString())- 1) * rowcount;

            inttotalCount=0;

            stringtitle=this.txtSearch.Text.Trim();

 

            List<VenuesInfo> vInfo = vc.GetQueryVenues(start,rowcount, title, out totalCount);

 

            this.GridView1.DataSource=vInfo;

            this.GridView1.DataBind();

 

            this.txtRows.Text= "";

            ViewState[this.ID + "totalPage"]= (totalCount / rowcount) + ((totalCount % rowcount) > 0 ? 1 : 0);

            labTotal.Text = "共" + totalCount.ToString() + "条记录 第" + ViewState[this.ID+ "startPage"].ToString() + "页/共" + ViewState[this.ID + "totalPage"].ToString() + "页";

        }

 

        ///<summary>

        ///查看数据

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid GridView1_SelectedIndexChanged(object sender, EventArgse)

        {

            intItemId = int.Parse(this.GridView1.DataKeys[this.GridView1.SelectedIndex].Value.ToString());

            //Response.Redirect(EditUrl((Session["itemId"]= ItemId).ToString(), "Edit"));

            ViewState[this.ID + "ItemId"]= ItemId;

            VenuesInfov = vc.GetQueryVenuesByItemId(ItemId);

            this.lblExhibitName.Text= v.ExhibitName.ToString();

            this.lblCreatedDate.Text= v.CreatedDate.ToString("yyyy-MM-dd");

            this.lblProjectExperience.Text= v.ProjectExperience.ToString();

            this.lblLinkman.Text= v.Linkman.ToString();

            this.lblEmail.Text= v.Email.ToString();

            this.lblLinkAddress.Text= v.LinkAddress.ToString();

 

            panList.Visible = true;

            panAdd.Visible = false;

            panView.Visible = false;

        }

 

        ///<summary>

        ///删除

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid GridView1_RowDeleting(object sender, GridViewDeleteEventArgse)

        {

            intItemId = int.Parse(this.GridView1.DataKeys[e.RowIndex].Value.ToString());

           vc.GetQueryDeleteVenue(ItemId);

            Binder();

        }

 

        ///<summary>

        ///绑定修改

        ///</summary>

        ///<paramname="sender"></param>

        ///<paramname="e"></param>

        protectedvoid GridView1_RowUpdating(object sender, GridViewUpdateEventArgse)

        {

            intItemId = int.Parse(this.GridView1.DataKeys[e.RowIndex].Value.ToString());

            panAdd.Visible = true;

            linkUpdate.Visible = true;

            panView.Visible = false;

            panList.Visible = false;

            linkSave.Visible = false;

 

            ViewState[this.ID + "ItemId"]= ItemId;

            VenuesInfov = vc.GetQueryVenuesByItemId(ItemId);

            this.txtExhibitName.Text= v.ExhibitName.ToString();

            this.txtLinkMan.Text= v.Linkman.ToString();

            this.txtExhibitIndicate.Text= v.ExhibitIndicate.ToString();

            this.txtPhone.Text= v.LinkPhone.ToString();

            this.txtEmail.Text= v.Email.ToString();

            this.txtQQ.Text= v.QQ.ToString();

            this.txtAddress.Text= v.LinkAddress.ToString();

            this.Label1.Text= v.ImageUrl.ToString();

            this.txtProjectExperience.Text= v.ProjectExperience.ToString();

            this.txtEquipmentDescription.Text= v.EquipmentDescription.ToString();

 

        }

 

 

VenuesController类：

///<summary>

        ///分页

        ///</summary>

        ///<paramname="Start"></param>

        ///<paramname="Count"></param>

        ///<paramname="ExhibitName"></param>

        ///<paramname="TotalCount"></param>

        ///<returns></returns>

        publicList<VenuesInfo>GetQueryVenues(int Start, int Count, stringExhibitName, out intTotalCount)

        {

            TotalCount = DataProvider.Instance().GetQueryVenuesCount(ExhibitName);

            returnCBO.FillCollection<VenuesInfo>(DataProvider.Instance().GetQueryVenues(Start,Count, ExhibitName));

        }

 

 

///<summary>

        ///分页记录数量

        ///</summary>

        ///<param name="ExhibitName"></param>

        ///<returns></returns>

        publicoverride intGetQueryVenuesCount(string ExhibitName)

        {

            return(int)SqlHelper.ExecuteScalar(ConnectionString,GetFullyQualifiedName("GetQueryVenuesCount"),ExhibitName);            

        }

 

        ///<summary>

        ///分页绑定

        ///</summary>

        ///<paramname="Start"></param>

        ///<paramname="Count"></param>

        ///<paramname="ExhibitName"></param>

        ///<returns></returns>

        publicoverride IDataReaderGetQueryVenues(int Start, int Count, stringExhibitName)

        {

            return(IDataReader)SqlHelper.ExecuteReader(ConnectionString,GetFullyQualifiedName("GetQueryVenues"),Start, Count, ExhibitName);

        }

 

存储过程：

CREATEPROCEDURE [dbo].[YourCompany_GetQueryVenues]

@Startint ,

@Countint,

@ExhibitName[varchar] (50)

as

selectidentity(int, 1,1) as indexid,ModuleId,ItemId*1ItemId,Content,CreatedByUser,CreatedDate,ExhibitName,Linkman,VisitsTatal,ImageUrl,ExhibitIndicate,LinkPhone,Email,QQ,LinkAddress,ProjectExperience,EquipmentDescriptioninto #newtable from Venues

       where ExhibitName like '%' + @ExhibitName+ '%' or ExhibitName is null

 

 

declare@sqlstr varchar(500)

set@sqlstr='select top ' + cast( @Count as varchar(20))+ 'ModuleId,ItemId,Content,CreatedByUser,

 CreatedDate,ExhibitName,Linkman,VisitsTatal,ImageUrl,ExhibitIndicate,LinkPhone,Email,QQ,LinkAddress,ProjectExperience,EquipmentDescriptionfrom #newtable where indexId not in ( select top ' + cast(@Start as varchar(20))+'

 indexId from #newtable order by CreatedDatedesc) order by CreatedDate desc'

execute(@sqlstr)

 

CREATEPROCEDURE [dbo].[YourCompany_GetQueryVenuesCount]

@ExhibitName[varchar] (50)

as

selectcount(*) from Venues where ExhibitName like '%' + @ExhibitName + '%' orExhibitName is null

GO

浅伤_
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
python 抓取ASP.NET平台信息 __VIEWSTATE
啦啦啦的博客
07-30 9468
为了妹子，简化她的工作，所以写了这个。。。。内网有个平台是ASP.net，刚开始没想到这么复杂。。开弓没有回头箭。。每打开一个网页都会有三次请求如图： 且每次请求所包含的__VIEWSTATE还有其他一些数据均不同。。。查了一下__VIEWSTATE，其本身也有防爬的作用，估计也就是增加了爬取的复杂度。总之这爬虫写的相当累。。代码中 class 只为了结构上好看些。。。爬取中正则写疯掉了
ViewState分页
09-22
1. **创建分页控件**：可以使用GridView、ListView或其他数据绑定控件，它们内置了分页功能。在控件中设置`AllowPaging="true"`来启用分页，并通过`PageSize`属性设置每页显示的数据量。 2. **处理分页事件**：数据...
viewstate的分页
yue1314zhupo的专栏
10-27 438
  private void bind()        {            int pageindex = (int)ViewState["pageindex"];            GridView1.DataSource = dh.GetStuinfo(pageindex);            GridView1.DataBind();           
GridView 和 ViewState 来实现条件查寻
weixin_30938149的博客
11-10 128
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 ...
理解Asp.net中的View state
旅途
06-07 937
什么是ViewState？对于ViewState，我们有许多的误解。Viewstate不保存控件，而是去保存form中对应ID控件的值，特别是那些由于他们没有和form一起post 而在页面回传时会丢失的控件的值。viewstate一般不要用来保存session或在页面间传输数据。在页面回传后，viewstate不能用来动态地创建页面的控件。他在页面回传之后不回复控件的值。甚至一个控件的views
数据分页(ViewState的用法)
weixin_30873847的博客
11-17 137
protectedSystem.Web.UI.WebControls.DataGridDataGrid1;privateDataTabledtPerson{set{this.ViewState["dt"]=value;}...
海量(大量)数据GridView显示高效率分页实现方法[定义].pdf
10-13
总结来说，处理大量数据的GridView分页实现方法主要包括：利用ViewState保存分页状态，计算总记录数和总页数，以及在数据绑定时仅获取当前页数据。这种策略可以有效避免一次性加载所有数据导致的性能问题，提高Web...
GridView手动分页
12-15
手动实现`GridView`分页虽然比使用内置功能复杂，但提供了更大的灵活性和控制力，可以满足更多定制化的需求。理解并掌握手动分页的实现原理和步骤，对于提升Web应用程序的用户体验和性能至关重要。
海量(大量)数据GridView显示高效率分页实现方法
09-26
### 海量数据GridView显示高效率分页实现方法 #### 背景介绍 在Web应用程序开发中，尤其是在使用ASP.NET框架时，处理大量的数据是非常常见的需求。然而，当需要在一个GridView控件中展示这些数据时，直接从数据库中...
GridView使用学习总结
10-23
根据提供的文件内容，下面是对标题《GridView使用学习总结》的详细知识点梳理： 1. GridView的引入与DataGrid的更替 在***技术发展中，旧的DataGrid数据绑定控件在VS2012版本后被GridView所取代。尽管视频教程可能...
asp.net中ViewState的用法详解
10-23
本文给大家介绍asp.net中viewstate的用法，涉及到viewstate的原理、用法、与session的对比等方面的知识，对viewstate用法感兴趣的朋友一起看看吧
gridview 在列表中对信息进行增删改，通过VIEWSTATE进行缓存，然后一次性将数据提交到服务器端。...
weixin_30355437的博客
05-27 91
为XX人写的DEMO样例，功能实现：gridview 在列表中对信息进行增删改，通过VIEWSTATE进行缓存，然后一次性将数据提交到服务器端。 下载地址：DOWNLOAD 代码： protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack)...
基于ViewState的分页控件
weixin_30323631的博客
12-16 74
1: public class PagInationControl : ECouponControl, IPostBackEventHandler 2: { 3: 4: public event EventHandler OnPageChanged; 5: 6: #region IPostBackEventHandler 成员 7: ...
GridView CheckBox当翻页时保存选中的项
weixin_30467087的博客
08-06 87
1属性保存全选的项#region属性保存全选的项23protectedArrayListSelectedItems4{5get6{7if(ViewState["SelectedItems"]==null)8{9Vi...
用ViewState实现GridView排序
点点滴滴
03-11 993
 1、Page_Load事件中设置初始值            ViewState["SortDirection"] = "ASC";            ViewState["SortExpression"] = "UserID";2、Sorting事件中设置排序表达式       // 设置排序表达式        ViewState["SortExpression"] = e.SortEx
ViewState，PagedDataSource实现分页功能
Wayne_C的Blog
01-15 554
之前一直在用aspnetpager这个分页控件，今天跟着用Viewstate和VS自带的PagedDataSource对象做了一个分页功能前台代码部分很简单，其实就四个按钮，不过，我自己增加了几个小功能，用于显示当前第几页和共有多少页 共条记录,当前第页，共有页
ASP.NET数据分页（使用viewstate）望大虾指正
tangtangcoding的专栏
03-30 341
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.
viewstate
thewebcode
06-13 167
viewstate1：保存值在 form表单的请求request中加到form表单中并且是服务器端的；（有点：能往返的保存值；缺点： viewstate每次请求都会将控件即值发送请求，会占用很大的网速） 这里form表单必须是服务器端的； 2：ViewState常用于保存单个用户的状态信息，有效期等于页面的生存期， 3：如果某个控件不需要在回发期间保存信息，最好将其ViewState属性...
ViewState的作用以及如何的理解ViewState
LYAom的专栏
12-30 2058
 ViewState用来保存往返页面和控制值，从而可以使新请求的页面恢复为提交页面的状态。 ViewState以加密方式保存在隐藏字段__ViewState__中  但是我有很大的疑问： 1>为什么TextBox的Color，MaxLength等属性也保存在ViewState中?(反编译可以看到) 2>TextBox的Text值本来就会回传到服务器，还为什么要保存在View
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值