一篇文章分页显示的源码（C#）

最新推荐文章于 2024-04-20 02:16:25 发布

wuxs

最新推荐文章于 2024-04-20 02:16:25 发布

阅读量925

点赞数

文章标签： c# button server asp database html

本文链接：https://blog.csdn.net/wuxs/article/details/841665

版权

<%@ 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" οnclick="Button1_Click_1" runat="server" Text="下一页"></asp:Button>
                        <asp:Button id="Button2" οnclick="Button2_Click" runat="server" Text="上一页"></asp:Button>
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</body>
</html>
这是分两页显示，可以在此基础上分多页显示。

wuxs

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
一篇文章分页显示的源码（C#）

SqlConnection cn; int textlen,prevlen,latelen; string text; void Page_Load(Object sender, EventArgs e) { cn =new SqlConnection("server=localhost;uid=sa;pwd=***;database=***");
复制链接

扫一扫