前台代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtselect" runat="server"></asp:TextBox>
<asp:Button ID="btnselect" runat="server" Text="查询" οnclick="btnselect_Click" />
</div>
<div id="divResult" runat="server"></div>
<table style="width: 25%;">
<tr>
<td>
<asp:Button ID="btnFirst" runat="server" Text="第一页" οnclick="btnFirst_Click" />
</td>
<td>
<asp:Button ID="btnPre" runat="server" Text="上一页" οnclick="btnPre_Click" />
</td>
<td>
<asp:Button ID="btnNext" runat="server" Text="下一页" οnclick="btnNext_Click" />
</td>
<td>
<asp:Button ID="btnLast" runat="server" Text="最后一页" οnclick="btnLast_Click" />
</td>
</tr>
</table>
</form>
</body>
</html>
后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Text;
namespace 新闻系统3
{
public partial class fenye2 : System.Web.UI.Page
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
int pagesize = 3;
//int pageindex = 1;
//int pagelastindex=0;
protected void Page_Load(object sender, EventArgs e)
{
PageCount();
if (!IsPostBack)
{
ViewState["pageindex"] = 1;
txtselect.Text = "";
DataLoad();
}
}
private void PageCount()
{
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select count(*) from T_News where NewsTitle like @newskey or NewsContent like @newskey";
cmd.Parameters.Add(new SqlParameter("@newskey","%" + txtselect.Text + "%"));
int pagecount=Convert.ToInt32(cmd.ExecuteScalar());
if (pagecount % pagesize == 0)
{
ViewState["pagelastindex"] = pagecount / pagesize;
}
else
{
ViewState["pagelastindex"] = pagecount / pagesize + 1;
}
}
}
}
private void DataLoad()
{
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select top (@pageSize) * from T_News where (NewsTitle like @newskey or NewsContent like @newskey) and Id not in (select top (@pageSize* (@pageIndex-1)) Id from T_News where NewsTitle like @newskey or NewsContent like @newskey ORDER by Id) order by Id";
cmd.Parameters.Add(new SqlParameter("@pageSize", pagesize));
cmd.Parameters.Add(new SqlParameter("@pageIndex",Convert.ToInt32(ViewState["pageindex"])));
cmd.Parameters.Add(new SqlParameter("@newskey", "%" + txtselect.Text + "%"));
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
StringBuilder sb1 = new StringBuilder();
sb1.Append("<table border=1>");
sb1.Append("<tr><td>标题</td><td>内容</td><td>创建时间</td></tr>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb1.Append("<tr>");
sb1.Append("<td>" + dt.Rows[i]["NewsTitle"] + "</td>");
sb1.Append("<td>" + dt.Rows[i]["NewsContent"] + "</td>");
sb1.Append("<td>" + dt.Rows[i]["CreateTime"] + "</td>");
sb1.Append("</tr>");
}
sb1.Append("</table>");
divResult.InnerHtml = sb1.ToString();
}
}
}
}
protected void btnFirst_Click(object sender, EventArgs e)
{
ViewState["pageindex"] = 1;
DataLoad();
}
protected void btnPre_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex > 1)
{
pageindex--;
ViewState["pageindex"] = pageindex;
DataLoad();
}
else
{
Response.Write("这已经是第一页了!");
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex <Convert.ToInt32(ViewState["pagelastindex"]))
{
pageindex++;
ViewState["pageindex"] = pageindex;
DataLoad();
}
else
{
Response.Write("这已经是最后一页了!");
}
}
protected void btnLast_Click(object sender, EventArgs e)
{
ViewState["pageindex"] = ViewState["pagelastindex"];
DataLoad();
}
protected void btnselect_Click(object sender, EventArgs e)
{
DataLoad();
}
}
}