<%@ 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>
这是分两页显示,可以在此基础上分多页显示。