gridview用ViewState做分页

最新推荐文章于 2013-06-13 14:08:00 发布
原创 最新推荐文章于 2013-06-13 14:08:00 发布 · 872 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#textbox #asp #object #server #exception #email

前台：

<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

asp.net viewState
Kaizen的博客
08-18 897
那么,有了这个隐藏域,页面里其他所有的控件的状态,包括页面本身的一些状态都会保存到这个控件值里面. 每次页面提交时一起提交到后台,asp.net对其中的值进行解码,然后输出时再根据这个值来恢复各个控件的状态. 我们再看这个控件的value值,它可能类似如下的形式:Oz4+O2w8aTwxPjs+O2w8…当请求某个页面时，ASP.NET会把所有控件的状态序列化成一个字符串，然后作为窗体的隐藏属性送到客户端，当客户端吧页面回传时，ASP.NET分析回传的窗体属性，并赋给控件对应的值。.........
ViewState分页
09-22
1. **创建分页控件**：可以使用GridView、ListView或其他数据绑定控件，它们内置了分页功能。在控件中设置`AllowPaging="true"`来启用分页，并通过`PageSize`属性设置每页显示的数据量。 2. **处理分页事件**：数据...
viewstate的分页
yue1314zhupo的专栏
10-27 483
  private void bind()        {            int pageindex = (int)ViewState["pageindex"];            GridView1.DataSource = dh.GetStuinfo(pageindex);            GridView1.DataBind();           
GridView 和 ViewState 来实现条件查寻
weixin_30938149的博客
11-10 163
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 1010
什么是ViewState？对于ViewState，我们有许多的误解。Viewstate不保存控件，而是去保存form中对应ID控件的值，特别是那些由于他们没有和form一起post 而在页面回传时会丢失的控件的值。viewstate一般不要用来保存session或在页面间传输数据。在页面回传后，viewstate不能用来动态地创建页面的控件。他在页面回传之后不回复控件的值。甚至一个控件的views
数据分页(ViewState的用法)
weixin_30873847的博客
11-17 171
protectedSystem.Web.UI.WebControls.DataGridDataGrid1;privateDataTabledtPerson{set{this.ViewState["dt"]=value;}...
海量(大量)数据GridView显示高效率分页实现方法[定义].pdf
10-13
总结来说，处理大量数据的GridView分页实现方法主要包括：利用ViewState保存分页状态，计算总记录数和总页数，以及在数据绑定时仅获取当前页数据。这种策略可以有效避免一次性加载所有数据导致的性能问题，提高Web...
ASP.NET GridView高效分页实现与ViewState应用
通过使用ViewState保持状态，配合有效的分页查询策略，可以有效地在GridView中展示大量数据，提高应用程序的性能和用户体验。在开发过程中，还应考虑优化数据库查询，如使用索引和适当的数据结构，以进一步提升性能...
基于jQuery实现GridView异步排序与分页
尤其是在使用jQuery UI Tabs组件动态加载包含服务端控件（如GridView）的外部页面时，常规的回发机制会导致整个页面重载或状态丢失，无法维持分页、排序等交互功能的状态连续性。该方案提出了一种基于AJAX的轻量级...
ASP.NET GridView控件排序与分页功能增强实现
GridView控件是ASP.NET 2.0中引入的一个功能强大且广泛使用的数据绑定控件，主要用于在Web页面上以表格形式展示和操作来自数据库或其他数据源的数据。它继承自BaseDataList类，提供了丰富的内置功能，如数据绑定、...
asp.net中ViewState的用法详解
10-23
本文给大家介绍asp.net中viewstate的用法，涉及到viewstate的原理、用法、与session的对比等方面的知识，对viewstate用法感兴趣的朋友一起看看吧
gridview 在列表中对信息进行增删改，通过VIEWSTATE进行缓存，然后一次性将数据提交到服务器端。...
weixin_30355437的博客
05-27 120
为XX人写的DEMO样例，功能实现：gridview 在列表中对信息进行增删改，通过VIEWSTATE进行缓存，然后一次性将数据提交到服务器端。 下载地址：DOWNLOAD 代码： protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack)...
基于ViewState的分页控件
weixin_30323631的博客
12-16 111
1: public class PagInationControl : ECouponControl, IPostBackEventHandler 2: { 3: 4: public event EventHandler OnPageChanged; 5: 6: #region IPostBackEventHandler 成员 7: ...
GridView CheckBox当翻页时保存选中的项
weixin_30467087的博客
08-06 125
1属性保存全选的项#region属性保存全选的项23protectedArrayListSelectedItems4{5get6{7if(ViewState["SelectedItems"]==null)8{9Vi...
用ViewState实现GridView排序
点点滴滴
03-11 1062
 1、Page_Load事件中设置初始值            ViewState["SortDirection"] = "ASC";            ViewState["SortExpression"] = "UserID";2、Sorting事件中设置排序表达式       // 设置排序表达式        ViewState["SortExpression"] = e.SortEx
ViewState，PagedDataSource实现分页功能
Wayne_C的Blog
01-15 598
之前一直在用aspnetpager这个分页控件，今天跟着用Viewstate和VS自带的PagedDataSource对象做了一个分页功能前台代码部分很简单，其实就四个按钮，不过，我自己增加了几个小功能，用于显示当前第几页和共有多少页 共条记录,当前第页，共有页
ASP.NET数据分页（使用viewstate）望大虾指正
tangtangcoding的专栏
03-30 379
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 218
viewstate1：保存值在 form表单的请求request中加到form表单中并且是服务器端的；（有点：能往返的保存值；缺点： viewstate每次请求都会将控件即值发送请求，会占用很大的网速） 这里form表单必须是服务器端的； 2：ViewState常用于保存单个用户的状态信息，有效期等于页面的生存期， 3：如果某个控件不需要在回发期间保存信息，最好将其ViewState属性...
GridView禁用掉viewstate之后的新建，编辑，删除
crazy7@youkuaiyun.com
09-01 2408
示例程序为一个超级Mini的图书管理，DB中只有一个名为"tableBook"的表，里面也只有三个字段ID(autonumber)，bookName,BookAuthor。效果图：Main.aspx: ...@ Page Language="C#" AutoEventWireup="true" CodeFile="Main.aspx.cs" Inherits="Main" 
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值