关于分页的问题

AllowCustomPaging 是自定义分页，你不使用自定义分页就去掉这个http://hbytw.sz.luohuedu.net/xml/ShowDetail.asp?id=B12283DE-DB20-4322-ACCC-12724442808A

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

贴代码。存储过程的例子可见http://www.dotnetjunkies.com/Tutorial/975BE770-E5DC-4610-870B-A82BDB9B8845.dcik
DateTime.Now.Month();取到月份，返回一个int
代码如下:
html:
aspx-html文件代码如下:
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="defen.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<TABLE id="Page_Head" height="27" cellSpacing="0" cellPadding="0" width="700" align="center" bgColor="honeydew" border="0">
<TR>
<TD width="180"><font size="2">请选择合适的组别:</font></TD>
<TD width="90"><asp:dropdownlist id="Drop_ZB" Runat="server" AutoPostBack="True"></asp:dropdownlist></TD>
<TD width="180"><font size="2">请选择相应的分店:</font></TD>
<TD width="200"><asp:dropdownlist id="Drop_FD" Runat="server" AutoPostBack="True"></asp:dropdownlist></TD>
<TD width="50"><asp:button id="Search" Runat="server" Text="查询"></asp:button></TD>
</TR>
</TABLE>
</FONT>
<br>
<div align="center"><asp:datagrid id="Data_Disp" runat="server" AutoGenerateColumns="False" CellPadding="4" BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#3366CC" Width="760px">
<SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
<ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#CCCCFF" BackColor="#003399"></HeaderStyle>
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="dzycode" HeaderText="号"></asp:BoundColumn>
<asp:BoundColumn DataField="dzyname" HeaderText="名"></asp:BoundColumn>
<asp:BoundColumn DataField="duifname" HeaderText="店"></asp:BoundColumn>
<asp:BoundColumn DataField="score" HeaderText="分"></asp:BoundColumn>
<asp:BoundColumn DataField="mingci" HeaderText="次"></asp:BoundColumn>
<asp:HyperLinkColumn Text="详情" Target="_blank" DataNavigateUrlField="dzyid" DataNavigateUrlFormatString="aaa.aspx?zyid={0}" HeaderText="操作" NavigateUrl="aaa.aspx"></asp:HyperLinkColumn>
</Columns>
</asp:datagrid></div>
</form>
</body>
</HTML>
cs代码如下private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
Fill_ZB();
Fill_FD();
start_page = 0;
}
} #region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Drop_ZB.SelectedIndexChanged += new System.EventHandler(this.Drop_ZB_SelectedIndexChanged);
this.Search.Click += new System.EventHandler(this.Search_Click);
this.Data_Disp.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.Data_Disp_PageIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Drop_ZB_SelectedIndexChanged(object sender, System.EventArgs e)
{
Fill_FD();

} private void Search_Click(object sender, System.EventArgs e)
{
//Response.Write(Drop_ZB.SelectedItem.Value.ToString());
Fill_Grid();

} public void Fill_ZB()
{
Open_Conn();
string strCommand = "select distinct group_sort from lsdtxb where group_sort is not NULL";
SqlDataAdapter objAdapter = new SqlDataAdapter(strCommand,objConnection);
DataSet objSet = new DataSet("data_zb");
objAdapter.Fill(objSet);
Drop_ZB.DataSource = objSet;
Drop_ZB.DataTextField = "group_sort";
Drop_ZB.DataValueField = "group_sort";
Drop_ZB.DataBind();
Close_Conn();
} public void Fill_FD()
{
Open_Conn();
string strCommand = "select distinct group_sort from lsdtxb where group_sort is not NULL";
strCommand = "select 'all' as duifbsh,'所有分店' as duifname union all select duifbsh,duifname from lsdtxb where group_sort ='" + Drop_ZB.SelectedItem.Value.ToString() + "'";
SqlDataAdapter objAdapter1 = new SqlDataAdapter(strCommand,objConnection);
DataSet objSet1 = new DataSet("data_fd");
objAdapter1.Fill(objSet1);
Drop_FD.DataSource = objSet1;
Drop_FD.DataTextField = "duifname";
Drop_FD.DataValueField = "duifbsh";
Drop_FD.DataBind();
Close_Conn();
}
public void Open_Conn()
{
if (objConnection.State == ConnectionState.Closed)
objConnection.Open();
}
public void Close_Conn()
{
if (objConnection.State == ConnectionState.Open)
objConnection.Close();
}

public void Fill_Grid()
{
Open_Conn();
SqlCommand objCommand = new SqlCommand("GET_DEFEN",objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
SqlParameter zubie = new SqlParameter("@zubie",SqlDbType.NVarChar,11);
objCommand.Parameters.Add(zubie);
zubie.Direction = ParameterDirection.Input;
zubie.Value = Drop_ZB.SelectedItem.Value.ToString();

SqlParameter month = new SqlParameter("@month",SqlDbType.Int);
objCommand.Parameters.Add(month);
month.Direction = ParameterDirection.Input;
month.Value = DateTime.Now.Month; Data_Disp.DataSource = objCommand.ExecuteReader();
Data_Disp.DataBind();
Close_Conn();
} private void Data_Disp_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
Data_Disp.CurrentPageIndex = e.NewPageIndex;
Fill_FD();
} }
}
为什么没人回答我的问题，我就是想把从存储过程里取出的数据，在DATAGRID里面实现分页显示而以，另外还想问两个问题：怎么样在一个字段上做一个FILTER，也即在DATAGRID上显示数据集时，只显示某个字段的值为给定值的纪录？
怎么样控制一个ASPX页面的大小及位置？
多谢了，公司催得急，各位高手帮忙了！！！