| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 604 人关注过本帖
标题:datagrid分页,点击哪一页都是相同的数据问题(保证不止这些数据)
只看楼主 加入收藏
点内起航
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2012-1-4
结帖率:0
收藏
 问题点数:0 回复次数:1 
datagrid分页,点击哪一页都是相同的数据问题(保证不止这些数据)
--------OnlineBook.aspx---------------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="OnlineBook.Index" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
           <div style="width:300px;float:right">
            <asp:Label ID="label2" runat="server" Text="用户名:"></asp:Label>
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
            <asp:Label ID="label3" runat="server" Text="密码: "></asp:Label>
            <asp:TextBox ID="password" runat="server" TextMode="Password" Width="138px"></asp:TextBox>
                    </div>
        <div style="width:300px; display:inline">
            &nbsp;<asp:Label ID="label1" runat="server" Text="节目查询"></asp:Label>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" />
            <asp:HyperLink ID="HyperLink1" runat="server">高级搜索</asp:HyperLink>
        </div>
 
    </div>
    <div>
        <asp:DataGrid ID="dgcom" Style="z-index: 111; left: 138px; position: absolute; top: 218px"
            Width="920px" BackColor="white" Height="182px" BorderColor="black" BorderStyle="None" AllowPaging="True"   AllowCustomPaging="true"
            PageSize="5"  BorderWidth="1" CellPadding="3"   OnPageIndexChanged="MyDataGrid_Page"
            AutoGenerateColumns="false" runat="server">
          <%--  <SelectedItemStyle Font-Bold="true" ForeColor="blue" BackColor="Black"></SelectedItemStyle>
    <AlternatingItemStyle BackColor="Blue"></AlternatingItemStyle>
           <ItemStyle ForeColor="Beige" BackColor="Blue"></ItemStyle>--%>
            <HeaderStyle Font-Bold="true" ForeColor="Beige" BackColor="black"></HeaderStyle>
           <%-- <FooterStyle ForeColor="#4A3C8C" BackColor="AliceBlue"></FooterStyle>--%>
            <Columns>
                <asp:BoundColumn HeaderText="书名" DataField="bookname" />
                <asp:BoundColumn HeaderText="作者" DataField="author" />
                <asp:BoundColumn HeaderText="出版社" DataField="address" />
                <asp:BoundColumn HeaderText="ISBN号" DataField="booknumber" />
                <asp:BoundColumn HeaderText="原价" DataField="yprice" />
                <asp:BoundColumn HeaderText="折扣" DataField="zhekou" />
            </Columns>
          <PagerStyle HorizontalAlign="Right" ForeColor="DarkGreen" BackColor="Red" Mode="NumericPages">
           </PagerStyle>
        </asp:DataGrid>
             <asp:Label ID="label4"
        Style="z-index: 114; left: 139px; position: absolute; top: 197px; width: 920px; height: 19px;"
        BackColor="InactiveCaptionText" BorderColor="black"
            BorderStyle="None" PageSize="5" GridLines="Horizontal" BorderWidth="1" CellPadding="3"
            AutoGenerateColumns="false" OnItemCommand="Grid_CartCommand"
            runat="server" Text="计算机类"></asp:Label>
    </form>
</body>
</html>
------OnlineBook.aspx.cs---------
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Collections;

namespace OnlineBook
{
    public partial class Index : System.Web.UI.Page
    {
        //DataSet getbata;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindGrid();

            }
                   }



        protected void Button1_Click(object sender, EventArgs e)
        {

        }
        public void BindGrid() {


            
            dgcom.DataSource = CreateDataSource();
            dgcom.VirtualItemCount = 16;
            dgcom.DataBind();
        
        }

      public void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e)
        {
           
            dgcom.CurrentPageIndex = e.NewPageIndex;
            BindGrid();
      
        }

      ICollection CreateDataSource() {

          string connectionstring = ConfigurationSettings.AppSettings["connectionstring"].ToString().Trim();//web.config的配置,在下面;
          string sql = "select * from bookinfo where T_type='计算机'";
          SqlConnection conn = new SqlConnection(connectionstring);
          //SqlCommand mycmd = new SqlCommand(sql, conn);
          conn.Open();
          SqlDataAdapter da = new SqlDataAdapter(sql, conn);
          DataTable bata1 = new DataTable();
          da.Fill(bata1);
          DataView dv = new DataView(bata1);
          return dv;
      }
    }
}
------web.config--------
<?xml version="1.0" encoding="utf-8"?>

<configuration>
    <system.web>
        <!--
            设置 compilation debug="true" 可将调试符号插入
            已编译的页面中。但由于这会
            影响性能,因此只在开发过程中将此值
            设置为 true。
        -->
        <compilation defaultLanguage="C#" debug="true">

        </compilation>
        <!--
            通过 <authentication> 节可以配置 用来
            识别进入用户的
            安全身份验证模式。
        -->
        <authentication mode="Windows" />
      <customErrors mode="RemoteOnly" />
      <authorization>
        <allow  users="*"/>  <!--允许所有用户-->
      </authorization>
        <!--
            如果在执行请求的过程中出现未处理的错误,
            则通过 <customErrors> 节可以配置相应的处理步骤。具体说来,
            开发人员通过该节可以配置
            要显示的 html 错误页
            以代替错误堆栈跟踪。

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
      <globalization  requestEncoding="utf-8" responseEncoding="utf-8"/>   
      <!--全球化
      此节设置应用程序的全球化设置-->
    </system.web>
  <appSettings>
<add key="connectionstring" value="server=localhost;uid=sa;pwd=sql2005;database=shop"/>
  </appSettings>
</configuration>

搜索更多相关主题的帖子: PUBLIC server title 
2012-01-05 14:17
playermaker
Rank: 2
等 级:论坛游民
威 望:1
帖 子:87
专家分:17
注 册:2008-8-15
收藏
得分:0 
事件错了
PageIndexChanging才对

[url=http://www.]优联(Union)官方网站[/url]
2012-01-20 13:58
快速回复:datagrid分页,点击哪一页都是相同的数据问题(保证不止这些数据)
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.014341 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved