我现在能显示出来了。但是不能分页。我要怎么进行分页查询啊??给自定义的表dt起个名字,然后用top子查询语句来查询然后分页么??我这个绑定的表是个虚拟的,也能查么??C#:Codeprivate void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
string flid = "1";
string url;
int hfCount = dl.huifuCount(flid);
if(hfCount<2)
{
url = "photo/lock_folder.gif";
}
else if(hfCount<4)
{
url = "photo/agree.gif";
}
else if(hfCount<8)
{
url = "photo/announcement_folder.gif";
}
else if(hfCount<10)
{
url = "photo/hot_folder.gif";
}
else
{
url = "photo/pin_3.gif";
}DataSet fabiaoDS = dl.fabiao(flid);
DataSet fbnrAllDS = dl.fbnrAll(flid);
ArrayList hfAllList = dl.huifuAll(flid);
ArrayList hfEndList = dl.huifuEnd(flid);
DateTime today = DateTime.Now.Date;
int hang = fabiaoDS.Tables[0].Rows.Count;
int fbnrCount = dl.huifuCount(flid);
string hftime = hfAllList[3].ToString();
string hfname = hfEndList[2].ToString();DataTable dt= new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("imagePath",typeof(String)));
dt.Columns.Add(new DataColumn("laba",typeof(String)));
dt.Columns.Add(new DataColumn("title",typeof(String)));
dt.Columns.Add(new DataColumn("news",typeof(String)));
dt.Columns.Add(new DataColumn("username",typeof(String)));
dt.Columns.Add(new DataColumn("fbnrCount",typeof(String)));
dt.Columns.Add(new DataColumn("xinqing",typeof(String)));
dt.Columns.Add(new DataColumn("hftime",typeof(String)));
dt.Columns.Add(new DataColumn("hfname",typeof(String)));for(int i=0;i<hang;i++)
{
string hfid = fbnrAllDS.Tables[0].Rows[i][0].ToString();
string title = fbnrAllDS.Tables[0].Rows[i][1].ToString();
string username = fbnrAllDS.Tables[0].Rows[i][3].ToString();
string fabiaoday = fbnrAllDS.Tables[0].Rows[i][4].ToString();
string xinqing = fbnrAllDS.Tables[0].Rows[i][6].ToString();dr= dt.NewRow();
dr[0] = "<IMG src="+url+">";
dr[1] = "<IMG height=16 src=photo/BMsg.gif width=16>";
dr[2] = "<A title="+title+" href=ShowTopic.asp?id="+hfid+">"+title+"</A>";
if(fabiaoday.Equals(today))
{
dr[3] = "<IMG height=11 src=photo/firstnew.gif width=28>";
}
else
{
dr[3] = "";
}
dr[4] = username;
dr[5] = fbnrCount;
dr[6] = "<img src='"+xinqing+"' width='19' height='19' border='0' >";
dr[7] = hftime;
dr[8] = hfname;
dt.Rows.Add(dr);
}
dlMyList.DataSource = dt;
dlMyList.DataBind();
}
}
HTML:Code<asp:DataList id="dlMyList" Width="750px" runat="server" ShowHeader="False" ShowFooter="False"
CssClass="yangshi.css">
<ItemTemplate>
<table cellSpacing="0" cellPadding="0" width="750" align="center" border="0">
<tr>
<td class="bbslist_zuoxiayou" vAlign="middle" align="center" width="40" height="35">
<%# DataBinder.Eval(Container.DataItem,"imagePath")%>
</td>
<td class="bbslist_huixia" vAlign="middle" width="325">
<%# DataBinder.Eval(Container.DataItem,"laba")%>
<%# DataBinder.Eval(Container.DataItem,"title")%>
</td>
<td width="77" align="center" valign="middle" class="bbslist_zuoxiayou">
<span class="TdA">
<%# DataBinder.Eval(Container.DataItem,"username")%>
</span>
</td>
<td width="55" align="center" valign="middle" class="bbslist_huixiayou">
<%# DataBinder.Eval(Container.DataItem,"fbnrCount")%>
</td>
<td width="55" align="center" valign="middle" class="bbslist_huixia">
<%# DataBinder.Eval(Container.DataItem,"xinqing")%>
</td>
<td width="198" align="center" valign="middle" class="bbslist_zuoxiayou">
<span class="TdA">
<%# DataBinder.Eval(Container.DataItem,"hftime")%>
<font color="red">|</font>
<%# DataBinder.Eval(Container.DataItem,"hfname")%>
</span>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
{
if(!IsPostBack)
{
string flid = "1";
string url;
int hfCount = dl.huifuCount(flid);
if(hfCount<2)
{
url = "photo/lock_folder.gif";
}
else if(hfCount<4)
{
url = "photo/agree.gif";
}
else if(hfCount<8)
{
url = "photo/announcement_folder.gif";
}
else if(hfCount<10)
{
url = "photo/hot_folder.gif";
}
else
{
url = "photo/pin_3.gif";
}DataSet fabiaoDS = dl.fabiao(flid);
DataSet fbnrAllDS = dl.fbnrAll(flid);
ArrayList hfAllList = dl.huifuAll(flid);
ArrayList hfEndList = dl.huifuEnd(flid);
DateTime today = DateTime.Now.Date;
int hang = fabiaoDS.Tables[0].Rows.Count;
int fbnrCount = dl.huifuCount(flid);
string hftime = hfAllList[3].ToString();
string hfname = hfEndList[2].ToString();DataTable dt= new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("imagePath",typeof(String)));
dt.Columns.Add(new DataColumn("laba",typeof(String)));
dt.Columns.Add(new DataColumn("title",typeof(String)));
dt.Columns.Add(new DataColumn("news",typeof(String)));
dt.Columns.Add(new DataColumn("username",typeof(String)));
dt.Columns.Add(new DataColumn("fbnrCount",typeof(String)));
dt.Columns.Add(new DataColumn("xinqing",typeof(String)));
dt.Columns.Add(new DataColumn("hftime",typeof(String)));
dt.Columns.Add(new DataColumn("hfname",typeof(String)));for(int i=0;i<hang;i++)
{
string hfid = fbnrAllDS.Tables[0].Rows[i][0].ToString();
string title = fbnrAllDS.Tables[0].Rows[i][1].ToString();
string username = fbnrAllDS.Tables[0].Rows[i][3].ToString();
string fabiaoday = fbnrAllDS.Tables[0].Rows[i][4].ToString();
string xinqing = fbnrAllDS.Tables[0].Rows[i][6].ToString();dr= dt.NewRow();
dr[0] = "<IMG src="+url+">";
dr[1] = "<IMG height=16 src=photo/BMsg.gif width=16>";
dr[2] = "<A title="+title+" href=ShowTopic.asp?id="+hfid+">"+title+"</A>";
if(fabiaoday.Equals(today))
{
dr[3] = "<IMG height=11 src=photo/firstnew.gif width=28>";
}
else
{
dr[3] = "";
}
dr[4] = username;
dr[5] = fbnrCount;
dr[6] = "<img src='"+xinqing+"' width='19' height='19' border='0' >";
dr[7] = hftime;
dr[8] = hfname;
dt.Rows.Add(dr);
}
dlMyList.DataSource = dt;
dlMyList.DataBind();
}
}
HTML:Code<asp:DataList id="dlMyList" Width="750px" runat="server" ShowHeader="False" ShowFooter="False"
CssClass="yangshi.css">
<ItemTemplate>
<table cellSpacing="0" cellPadding="0" width="750" align="center" border="0">
<tr>
<td class="bbslist_zuoxiayou" vAlign="middle" align="center" width="40" height="35">
<%# DataBinder.Eval(Container.DataItem,"imagePath")%>
</td>
<td class="bbslist_huixia" vAlign="middle" width="325">
<%# DataBinder.Eval(Container.DataItem,"laba")%>
<%# DataBinder.Eval(Container.DataItem,"title")%>
</td>
<td width="77" align="center" valign="middle" class="bbslist_zuoxiayou">
<span class="TdA">
<%# DataBinder.Eval(Container.DataItem,"username")%>
</span>
</td>
<td width="55" align="center" valign="middle" class="bbslist_huixiayou">
<%# DataBinder.Eval(Container.DataItem,"fbnrCount")%>
</td>
<td width="55" align="center" valign="middle" class="bbslist_huixia">
<%# DataBinder.Eval(Container.DataItem,"xinqing")%>
</td>
<td width="198" align="center" valign="middle" class="bbslist_zuoxiayou">
<span class="TdA">
<%# DataBinder.Eval(Container.DataItem,"hftime")%>
<font color="red">|</font>
<%# DataBinder.Eval(Container.DataItem,"hfname")%>
</span>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
=======================================
MS SQL 中用select top来查询。MySQL中用limit n,m。给自定义的表dt起个名字,然后用top子查询语句来查询然后分页么??
========================================================
可以的。我这个绑定的表是个虚拟的,也能查么??
===============================
所谓虚拟什么意思,视图吗?视图是支持的。如果是内存中的表的话,那就没有必要用自定义分页了。
自定义分页的作用的每次只从数据库取出要显示的数据,提高效率。
看看 ASPNETPager 这个不错的对你有帮助的 提供存储过程分页
然后在html里用项模版定义表格样式,将这个DataTable绑定到了DataList里面。但是我不能不分页直接显示啊。那50多条主题,页面得多长啊~~分页查询不是得用top(top)数据语句来查询,对吧~~~
但是我要查询分页显示的表是一个拼出来的,实际上并不存在的。我怎么查啊???
就这不懂了~~~!!
但是我要查询分页显示的表是一个拼出来的,实际上并不存在的。我怎么查啊???================>
创建视图,然后对视图进行查询