ÔÚÏߵȣ¡ Èý²ã¼Ü¹¹ SQL ת Accessºó³öÏÖµÄÎÊÌ⣡
¼ò½é£ºÀûÓà ASPNETPAGER1 ¶ÁÈ¡ÐÂÎÅ
³öÏֵĴíÎó£ºÎ´½«¶ÔÏóÒýÓÃÉèÖõ½¶ÔÏóµÄʵÀý¡£ ÐÐ 131: }
ÐÐ 132: List <News> List_News = new List <News>();
ÐÐ 133: while (rec.Read())
ÐÐ 134: {
ÐÐ 135: News news = new News();
Ô´ÂëÈçÏ£º
Óû§½çÃæ´úÂ룺
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
BinData();
}
public void BinData()
{
NewsSystem newsSystem = new NewsSystem();
News_List.DataSource = newsSystem.Get_News(Convert.ToInt32(AspNetPager1.PageSize), AspNetPager1.CurrentPageIndex-1);
News_List.DataBind();
}
BLL²ã´úÂ룺
/// <summary>
/// ²é¿´È«²¿
/// </summary>
/// <param name="pageNum">ÿҳÏÔʾµÄÊýÄ¿ </param>
/// <param name="currentPage">µ±Ç°Ò³ </param>
&n
Ïà¹ØÎÊ´ð£º
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......