<asp:GridView ID="gv_citylist" runat="server" AutoGenerateColumns="False" Width="100%"
BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px"
CellPadding="4" GridLines="Horizontal">
<RowStyle BackColor="White" ForeColor="#333333" HorizontalAlign="Center" />
<Columns>
<asp:TemplateField HeaderText="活动标题">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("c_c_title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="活动内容">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("c_c_content") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="活动时间">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Eval("c_c_time","{0:yyyy-MM-dd}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="活动地点">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Eval("c_c_address") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<webdiyer:AspNetPager ID="AspNetPagerclub" CssClass="paginator" CurrentPageButtonClass="cpb"
runat="server" AlwaysShow="True" FirstPageText="首页" LastPageText="尾页" NextPageText="下一页"
PageSize="20" PrevPageText="上一页" ShowCustomInfoSection="Left" ShowInputBox="Never"
OnPageChanged="AspNetPagerclub_PageChanged" CustomInfoTextAlign="Left" LayoutType="Table"
EnableUrlRewriting="false" UrlRewritePattern="~/Url_Page{0}.html" SubmitButtonClass="SubmitBtn"
SubmitButtonText="转到" PageIndexBoxClass="PageIndexBox" ShowPageIndexBox="Never"
HorizontalAlign="Right">
</webdiyer:AspNetPager>
调用存储过程
public static DataTable PageView(string tbname, string FieldKey, int PageCurrent, int PageSize, string FieldShow, string Where, string FieldOrder, ref int RecordCount)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@tbname",SqlDbType.VarChar),
new SqlParameter("@FieldKey",SqlDbType.VarChar,1000),
new SqlParameter("@PageCurrent",SqlDbType.Int),
new SqlParameter("@PageSize",SqlDbType.Int),
new SqlParameter("@FieldShow",SqlDbType.VarChar,1000),
new SqlParameter("@Where",SqlDbType.VarChar,1000),
new SqlParameter("@FieldOrder",SqlDbType.VarChar,1000),
new SqlParameter("@PageCount",SqlDbType.Int),
new SqlParameter("@RecordCount",SqlDbType.Int),
};
parms[0].Value = tbname;
parms[1].Value = FieldKey;
parms[2].Value = PageCurrent;
parms[3].Value = PageSize;
parms[4].Value = FieldShow;
parms[5].Value = Where;
parms[6].Value = FieldOrder;
parms[7].Direction = ParameterDirection.Output;
parms[8].Direction = ParameterDirection.Output;
DataTable dt = new DataTable();
SQLHelper.FillDataTablePage("PageView", dt, parms);
RecordCount = Convert.ToInt32(parms[8].Value);
return dt;
}
/// <summary>
/// 执行一个SQL查询,填充DataTable
/// </summary>
/// <param name="cmdText"></param>
/// <param name="dt"></param>
/// <param name="cmdParms"></param>
public static void FillDataTablePage(string cmdText, DataTable dt, params SqlParameter[] cmdParms)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(CONN_STRING))
{
PrepareCommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, cmdParms);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(dt);
ada.Dispose();
}
}
int RecordCount;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Initial();
}
}
protected void Initial()
{
DataTable dt = PageDAL.PageView("club_city", "c_c_id", this.AspNetPagerclub.CurrentPageIndex, this.AspNetPagerclub.PageSize, "*", "", "", ref RecordCount);
this.AspNetPagerclub.RecordCount = RecordCount;
this.AspNetPagerclub.CustomInfoHTML = string.Format("当前第{0}/{1}页 共{2}条记录 每页{3}条", new object[] { this.AspNetPagerclub.CurrentPageIndex, this.AspNetPagerclub.PageCount, this.AspNetPagerclub.RecordCount, this.AspNetPagerclub.PageSize });
if (dt.Rows.Count == 0)
{
dt.Rows.Add(dt.NewRow());
this.gv_citylist.DataSource = dt;
this.gv_citylist.DataBind();
int columnCount = dt.Columns.Count;
gv_citylist.Rows[0].Cells.Clear();
gv_citylist.Rows[0].Cells.Add(new TableCell());
gv_citylist.Rows[0].Cells[0].ColumnSpan = columnCount;
gv_citylist.Rows[0].Cells[0].Text = "没有符合条件的数据!";
gv_citylist.Rows[0].Cells[0].Style.Add("text-align", "left");
gv_citylist.Rows[0].Cells[0].Style.Add("color", "red");
}
else
{
this.gv_citylist.DataSource = dt;
this.gv_citylist.DataBind();
}
}
protected void AspNetPagerclub_PageChanged(object sender, EventArgs e)
{
Initial();