Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚÏߵȣ¡ Èý²ã¼Ü¹¹ 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 º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--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 ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ