我在前台直接拖了一个datalist控件(datalist1),什么都没有设置,后台cs的一个button_click事件中经过访问数据库动态生成了一个datatable dt如下:
protected void Button_Click(object sender, EventArgs e)
{
datatable dt;
中间动态生成datatable省略。
然后
datalist1.datasource=dt;
datalist1.databand();
}
我有AspNetPager.dll
怎么绑定datalist1或者先绑定dt?额滴神啊!!!asp.net分页datalist
protected void Button_Click(object sender, EventArgs e)
{
datatable dt;
中间动态生成datatable省略。
然后
datalist1.datasource=dt;
datalist1.databand();
}
我有AspNetPager.dll
怎么绑定datalist1或者先绑定dt?额滴神啊!!!asp.net分页datalist
RepeatColumns="4"
Style="margin-bottom: 0px">
<ItemTemplate>
<td height="135">
<img src="../../images/Article/<%#Eval("ArticlePhotos") %>" alt="" width="200" height="150">
<br />
<div style="text-align: left">
<img src="../../Web/images/dian3.gif" width="12" height="11" alt="" />
<%#Eval("ArticleTitle").ToString().Trim().Length > 10 ? (Eval("ArticleTitle").ToString().Substring(0, 10)) : Eval("ArticleTitle").ToString() + "..."%>
</div>
<br />
</td>
<td height="135">
</td>
</ItemTemplate>
</asp:DataList>后台绑定: protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = DBSql.Query("select top 12 * from Article where ArticlePhotos not like '' and ArticleState <> 1 order by ArticleID desc");
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string ArticleTitle = "";
if (ds.Tables[0].Rows[i]["ArticleTitle"] != null && ds.Tables[0].Rows[i]["ArticleTitle"].ToString() != "")
{
ArticleTitle = helper.DealWord(ds.Tables[0].Rows[i]["ArticleTitle"].ToString());
}
else
{
ds.Tables[0].Rows[i]["ArticleTitle"] = "...";
}
string ArticlePhotos = ds.Tables[0].Rows[i]["ArticlePhotos"].ToString();
}
dlShow.DataSource = ds;
dlShow.DataBind();
}
}
this.AspNetPager1.RecordCount = 记录总条数;
this.AspNetPager1.PageSize = 30;
然后还要加上AspNetPager1的事件:AspNetPager1_PageChanged(object sender, EventArgs e)
{
分页的页码 = this.AspNetPager1.CurrentPageIndex;
GetDataSource();//初始化数据的方法
}