asp分页求助
我有两个页面,right.asp,search.asp.我在search.asp中用Request.Form("")取到了right.asp中多个表单的一些值.
在search.asp中能查出一部分的东西,但是在点击下一页的时间就没有数据了(我的分页是dw自动生成的),
页面效果如下:a------/control/outreplayvedio/search_index.asp-------------------
UserID=-1
StationID=2
choseproperty=1
begindate=2010-02-04
enddate=2010-06-08
coursewarename=
classname=
teachername=
SELECT c.StationID, s.StationName,a.CameraSign,a.FileBeginTime,a.FileEndTime,a.coursewarename, a.classname,a.teachername FROM ArchiveFile a INNER JOIN Camera c ON a.CameraSign = c.CameraSign INNER JOIN Station s ON s.StationID = c.StationID AND (CONVERT(varchar(10),a.FileBeginTime,120) BETWEEN '2010-02-04' AND '2010-06-08') AND (c.StationID = 2) AND (a.CameraSign = (SELECT TOP 1 CameraSign AS csign FROM Camera WHERE StationID = 2))
URL-------------/control/outreplayvedio/search_index.asp?UserID=%2D1&StationID=2&begindate=2010%2D02%2D04&enddate=2010%2D06%2D08&submit=%BC%EC%CB%F7&coursewarename=&teachername=&classname=&choseproperty=1&offset=
但是点下一页时就成这样了
a------/control/outreplayvedio/search_index.asp-------------------
UserID=-1
StationID=2
choseproperty=1
begindate=2010-02-04
enddate=2010-06-08
coursewarename=
classname=
teachername=
SELECT c.StationID, s.StationName,a.CameraSign,a.FileBeginTime,a.FileEndTime,a.coursewarename, a.classname,a.teachername FROM ArchiveFile a INNER JOIN Camera c ON a.CameraSign = c.CameraSign INNER JOIN Station s ON s.StationID = c.StationID AND (CONVERT(varchar(10),a.FileBeginTime,120) BETWEEN '2010-02-04' AND '2010-06-08') AND (c.StationID = 2) AND (a.CameraSign = (SELECT TOP 1 CameraSign AS csign FROM Camera WHERE StationID = 2))
URL-------------/control/outreplayvedio/search_index.asp?UserID=%2D1&StationID=2&begindate=2010%2D02%2D04&enddate=2010%2D06%2D08&submit=%BC%EC%CB%F7&coursewarename=&teachername=&classname=&choseproperty=1&offset=
请问有没有高手能帮着解决一下,急!! --------------------编程问答-------------------- 看着DW生成的页面就头疼 --------------------编程问答-------------------- 我也头疼,有什么办法呢,是公司的事情 --------------------编程问答-------------------- lz可以使用GridView,它自带的有分页功能。具体可参考:
<asp:GridView ID="gvUserInfo" runat="server" AutoGenerateColumns="False" CellPadding="3" Width="100%" OnRowCommand="gvUserInfo_RowCommand" OnRowDataBound="gvUserInfo_RowDataBound" style="border-right: gray 1px solid; border-top: gray 1px solid; border-left: gray 1px solid; border-bottom: gray 1px solid" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" OnRowEditing="gvUserInfo_RowEditing" PageSize="4" AllowPaging="True" OnPageIndexChanging="gvUserInfo_PageIndexChanging1">
<FooterStyle BackColor="White" ForeColor="#000066" />
<RowStyle ForeColor="#000066" BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerSettings FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PreviousPageText="上一页" />
</asp:GridView>
代码部分:
protected void gvUserInfo_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
this.gvUserInfo.PageIndex = e.NewPageIndex;
this.gvDataBind();
} --------------------编程问答-------------------- lz可以使用GridView,它自带的有分页功能。具体可参考:
<asp:GridView ID="gvUserInfo" runat="server" AutoGenerateColumns="False" CellPadding="3" Width="100%" OnRowCommand="gvUserInfo_RowCommand" OnRowDataBound="gvUserInfo_RowDataBound" style="border-right: gray 1px solid; border-top: gray 1px solid; border-left: gray 1px solid; border-bottom: gray 1px solid" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" OnRowEditing="gvUserInfo_RowEditing" PageSize="4" AllowPaging="True" OnPageIndexChanging="gvUserInfo_PageIndexChanging1">
<FooterStyle BackColor="White" ForeColor="#000066" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox runat ="server" ID="cbUserInfo"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="UserId" HeaderText="用户名" />
<asp:BoundField DataField="Type" HeaderText="类型" />
<asp:BoundField DataField="CreatePerson" HeaderText="创建人" />
<asp:BoundField DataField="CreateTime" HeaderText="创建时间" />
<asp:BoundField DataField="Memo" HeaderText="备注" />
<asp:ButtonField CommandName="Detail" Text="详细信息" />
<asp:ButtonField CommandName="Edit" Text="编辑" />
</Columns>
<RowStyle ForeColor="#000066" BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerSettings FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PreviousPageText="上一页" />
</asp:GridView>
代码部分:
protected void gvUserInfo_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
this.gvUserInfo.PageIndex = e.NewPageIndex;
this.gvDataBind();
} --------------------编程问答-------------------- lz可以使用GridView,它自带的有分页功能。具体可参考:
<asp:GridView ID="gvUserInfo" runat="server" AutoGenerateColumns="False" CellPadding="3" Width="100%" OnRowCommand="gvUserInfo_RowCommand" OnRowDataBound="gvUserInfo_RowDataBound" style="border-right: gray 1px solid; border-top: gray 1px solid; border-left: gray 1px solid; border-bottom: gray 1px solid" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" OnRowEditing="gvUserInfo_RowEditing" PageSize="4" AllowPaging="True" OnPageIndexChanging="gvUserInfo_PageIndexChanging1">
<FooterStyle BackColor="White" ForeColor="#000066" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox runat ="server" ID="cbUserInfo"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="UserId" HeaderText="用户名" />
<asp:BoundField DataField="Type" HeaderText="类型" />
<asp:BoundField DataField="CreatePerson" HeaderText="创建人" />
<asp:BoundField DataField="CreateTime" HeaderText="创建时间" />
<asp:BoundField DataField="Memo" HeaderText="备注" />
<asp:ButtonField CommandName="Detail" Text="详细信息" />
<asp:ButtonField CommandName="Edit" Text="编辑" />
</Columns>
<RowStyle ForeColor="#000066" BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerSettings FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PreviousPageText="上一页" />
</asp:GridView>
代码部分:
protected void gvUserInfo_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
this.gvUserInfo.PageIndex = e.NewPageIndex;
this.gvDataBind();
}
补充:.NET技术 , ASP.NET