asp.net Ò³Ãæ¾²Ì¬»¯·½°¸
ÔÚ×î½üµÄÓÃasp.net ¿ª·¢µÄÏîÄ¿ÖУ¬×öÓÅ»¯£¬Òª°ÑÒ³Ãæ¾²Ì¬»¯£¬²éÁ˺ܶàÖÖ·½·¨£¬×îºóÑ¡ÔñÁËÓÃÄ£°åÀ´ÊµÏÖ£¬
×îÖÕÒ³µÄʵÏֱȽϼòµ¥£¬ÔÚÍøÉÏÕÒÁËÒ»¶Î´úÂ룬µ«Ê×Ò³£¬¶þ¼¶Ò³£¬ÁбíÒ³µÄ´¦Àí±¾ÈËÊÇÓõÄÒÔÏ·½°¸£¬ÏÖÔÚ»¹Ö»ÊÇÒ»¸ö±È½Ï¼òµ¥µÄ£¬Ï£ÍûÓдó¼Ò¶à¶àÖ¸µã£¬½»Á÷£»
·½·¨ÈçÏ£º
˼·ÃèÊö£º
1£¬ÔÚÄ£°åÖÐ×Ô¼ºÐ´Ñ»·£¬Í¨¹ýasp.net ¶ÁÈ룬ÔÙ½âÎö£»
2£¬ÔÙ°´Ñ»·Ìõ¼þµ½Êý¾Ý¿â¶ÁÈ¡Êý¾Ý£¬ÓÃÌæ»»Ñ»·ÄڵıäÁ¿£»
3£¬×îºó·µ»ØÌæ»»ºóµÄ×Ö·û´®£¬Éú³É¾²Ì¬Îļþ£»
Ä£°åÑùʽ´úÂ룺
#foreach{News_Article;row_number() over(order by News_CreateTime desc) as rowNumber,News_Type,News_Title,News_HtmlFileName,News_Count;limit(0,1)|order(News_CreateTime desc)|types(in('0103'))|important(in('1'))|isnominate(1)|style(1)|define()}
<li>
<div class="sx">$News_Article.rowNumber</div>
<a href="$News_Article.News_HtmlFileName" target="_blank" title="$News_Article.News_Title;[µã»÷Êý£º$News_Article.News_Count]">$News_Article.News_Title</a>
</li>
#endforeach
ÁбíÒ³Ñùʽ´úÂ룺
#foreach{News_Article;row_number() over(order by News_CreateTime desc) as rowNumber,News_Type,News_Title,News_HtmlFileName,News_Count;limit(0,1)|order(News_CreateTime desc)|types(not in ('0104'))|important(not in('0'))|isnominate(1)|style(1)|define();page(20)}
<li>
<div class="sx">$News_Article.rowNumber</div>
<a href="$News_Article.News_HtmlFileName" target="_blank" title="$News_Article.News_Title;[µã»÷Êý£º$News_Article.News_Count]">$News_Article.News_Title</a>
</li>
#endforeach
˵Ã÷£º#foreach #endforeach ÕâÊÇ×Ô¶¨ÒåÑ»·Ì壬News_ArticleÊý¾Ý¿â±íÃû£¬
row_number() over(order by News_CreateTime desc) as rowNumber,News_Type,News_Title,News_HtmlFileName,News_Count;ÏÔʾ×Ö¶ÎÃû£¬
limit(0,1)|order(News_CreateTime desc)|types(in('0103'))|important(in('1'))|isnominate(1)|style(1)|define()Ìõ¼þ
page(20)·ÖÒ³ÌõÊý£»
$News_Article.rowNumberÑ»·Ìå±äÁ¿
´¦Àí·½·¨£º
/// <summary>
Ïà¹ØÎĵµ£º
//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ·
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ·
///
/// È¡µÃdataset
//
/// ²éѯÓï¾ä
///
public DataSet GetDataSet(string Commandtext)
{&nbs ......
´óѧÉú»î£¬ºÜÄÑ˵£¬¸÷ÖÖÌå»áºÍ×Ì棬ÒòÈ˶øÒì
´óѧѧϰ£¬¸üÄÑ˵£¬¸÷Öֳɼ¨ºÍϹ»ì£¬¸÷ÓÐǧÇï
ºÜ¶àʱºò×ÜÊÇÔÚÏ룬ÕâЩÄêÀ´µ½µ×ѧµ½ÁËʲô£¬×÷Ϊһ¸ö´óѧÉú£¬±ÈÆðÄÇЩÉç»áÉϵĻì»ìµ½µ×ÓÐʲôÓÅÊÆ¡£Ã»Óд𰸣¬ÖÁÉÙÏÖÔÚûÓÐ
ºÜ¶àʱºò¶Ôѧϰ³äÂúÏ£Íû£¬µ«Äǽö½öÖ»ÊÇÍ£ÁôÔÚÄÔº£Öеļƻ®£¬¼¸ºõûÓйýʵÏÖ¡£
´óѧµÄ»ù´¡¿ÎºÜÖØÒª£¬ ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;//ÒýÈëÃüÃû¿Õ¼ä ......
Ò³ÃæµØÖ·ÊÇ:http://www.mldn.cn/articleview/2007-2-6/article_view_1400.htm
Web·þÎñµÄinetinfo.exeÓëOracleµÄApache.exe½ø³ÌËùÕ¼ÓõĶ˿ڶ¼°üÀ¨80¶Ë¿Ú¡£
Èç¹ûÓû§ÊÇÔÚ°²×°ÁËOracleÖ®ºó£¬ÔÙʹÓÃ.NET´´½¨ASP.NETÓ¦ÓóÌÐò³öÏÖÏÂÃæÇé¿öµÄ´íÎó£º
VS.NET¼ì²âµ½web·þÎñÆ÷ÔËÐеÄÊÇASP.NET 1.0°æ£¬Òª´´½¨»ò´ò¿ªµÄÓ¦ÓóÌÐò¿ÉÒ ......