一篇文章分页显示的源码(C#)

来源:互联网 发布:留学申请 知乎 编辑:程序博客网 时间:2024/05/17 08:57
 
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

    SqlConnection cn;
    int textlen,prevlen,latelen;
    string text;

    void Page_Load(Object sender, EventArgs e) {
    cn =new SqlConnection("server=localhost;uid=sa;pwd=***;database=***");
    SqlDataAdapter da = new SqlDataAdapter("select text from test",cn);
    DataSet ds=new DataSet();
    da.Fill(ds,"text");
    text=ds.Tables["text"].Rows[0][0].ToString();
    textlen=text.Length;
    prevlen=text.LastIndexOf("p>",14000)+2;
    latelen=textlen-prevlen;
    Label2.Text=text.Substring(0,prevlen);

    }

    void Button1_Click_1(object sender, EventArgs e) {
    Label2.Text=text.Substring(prevlen,latelen);
    }

    void Button2_Click(object sender, EventArgs e) {
    Label2.Text=text.Substring(0,prevlen);
    }

</script>
<html>
<head>
</head>
<body topmargin="0">
    <form runat="server">
        <table width="550" align="center">
            <tbody>
                <tr>
                    <td>
                        <asp:Label id="Label2" runat="server">Label</asp:Label></td>
                </tr>
                <tr>
                    <td align="middle">
                        <asp:Button id="Button1" onclick="Button1_Click_1" runat="server" Text="下一页"></asp:Button>
                        <asp:Button id="Button2" onclick="Button2_Click" runat="server" Text="上一页"></asp:Button>
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</body>
</html>
这是分两页显示,可以在此基础上分多页显示。