帮我写个分页的程序?(c# Sqlserver)

来源:百度知道 编辑:UC知道 时间:2024/06/04 12:22:28
具体如下:
四个linkbutton
首页 上一页,下一页,尾页

自动分页功能.

<%@ Import Namespace="System.Data"%>
<br><%@ Import Namespace="System.Data.SqlClient" %>
<br><script language="C#" runat="server">
<br>void Page_load()
<br>{
<br>if (!IsPostBack)
<br>{
<br>string strConnection = "server=127.0.0.1;";
<br>strConnection += "database=ztx;uid=sa;password=wxj;";
<br>SqlConnection sqlConnection1 = new SqlConnection(strConnection);
<br>string strSql = "select top 20 i_id,i_caption,i_count,substring(i_content,1,20) as i_content from content";
<br>SqlDataAdapter sqlAdapter = new SqlDataAdapter(strSql, sqlConnection1);
<br>DataSet objDataSet = new DataSet();
<br>sqlAdapter.Fill(objDataSet);
<br>ViewState["objDataSet"]=objDataSet
<br>bind();
<br>}
<br>}
<br&