ADO.NET³ÌÐòÉè¼ÆÄ£ÄâÌâ(¹²206Ìâ)
1
ADO.NET Ä£ÐÍÖеÄÏÂÁÐÄÄЩ¶ÔÏóÊôÓÚConnected ¶ÔÏó
A. Connection
B. DataAdapter
C. DataReader
D. DataSet
ÕýÈ·´ð°¸:ABC
2
ÔÚADO.NET ÖÐ,Ϊ·ÃÎÊDataTable ¶ÔÏó´ÓÊý¾ÝÔ´ÌáÈ¡µÄÊý¾ÝÐÐ.¿ÉʹÓÃDataTable ¶ÔÏóµÄ_______ÊôÐÔ.
A. Rows
B. Columns
C. Constraints
D. DataSet
ÕýÈ·´ð°¸:A
3
ÔÚADO.NET ÖÐʹÓÃXML Ö§³Öʱ,ÒÔÏÂÄÄЩ½¨ÒéÊÇ¿ÉÈ¡µÄ
A. ´ÓDataSet ¶ÁÈ¡XML ¸ñʽµÄÊý¾Ý
B. ʹÓÃXML ¸ñʽµÄÊý¾ÝÌî³äDataSet
C. ΪDataSet ´´½¨XML ¸ñʽµÄ¹¹¼ÜÃèÊö
D. ½«Êý¾ÝÒÔXML ¸ñʽ±£´æÔÚÊý¾Ý¿âÖÐ
ÕýÈ·´ð°¸:ABC
4
Ŀǰ,Microsoft .NET Framework µÄ·¢ÐаüÖаüº¬ÒÔÏÂ.NET Êý¾ÝÌṩ³ÌÐò.
A. SQL Server .NET Êý¾ÝÌṩ³ÌÐò
B. OLE DB .NET Êý¾ÝÌṩ³ÌÐò
C. ODBC .NET Êý¾ÝÌṩ³ÌÐò
D. XML .NET Êý¾ÝÌṩ³ÌÐò
ÕýÈ·´ð°¸:AB(51aspx)
5
Ϊ·ÃÎÊMicrosoft Access 2000 Êý¾Ý¿âÖеÄÊý¾Ý,¿ÉÒÔʹÓÃÒÔÏÂÄÄÖÖ.NET Êý¾ÝÌṩÕßÁ¬½Óµ½Êý¾Ý¿â
A. SQL Server .NET Êý¾ÝÌṩ³ÌÐò
B. OLE DB .NET Êý¾ÝÌṩ³ÌÐò
C. ODBC .NET Êý¾ÝÌṩ³ÌÐò
D. XML .NET Êý¾ÝÌṩ³ÌÐò
ÕýÈ·´ð°¸:BC
6
ΪÁËÔÚ³ÌÐòÖÐʹÓÃODBC .NET Êý¾ÝÌṩ³ÌÐò,Ó¦ÔÚÔ´³ ......
ASP.NETµÄÒ³Ãæ³õʼ»¯ÓëʼþÏê½â
Ò»¡¢³õʼ»¯
¡¡¡¡·µ±Ò³Ãæ±»Ìá½»ÇëÇóµÚÒ»¸ö·½·¨ÓÀÔ¶Êǹ¹Ô캯Êý¡£Äú¿ÉÒÔÔÚ¹¹Ô캯ÊýÀïÃæ³õʼһЩ×Ô¶¨ÒåÊôÐÔ»ò¶ÔÏ󣬲»¹ýÕâʱºòÒòÎªÒ³Ãæ»¹Ã»Óб»ÍêÈ«³õʼ»¯ËùÒÔ¶àÉÙ»áÓÐЩÏÞÖÆ¡£ÌØ±ðµØ£¬ÄúÐèҪʹÓÃHttpContext¶ÔÏó¡£µ±Ç°¿ÉÒÔʹÓõĶÔÏó°üÀ¨QueryString, FormÒÔ¼°Cookies¼¯ºÏ£¬»¹ÓÐCache¶ÔÏó¡£×¢Ò⣺ÔÚ¹¹Ô캯ÊýÀïÊDz»ÔÊÐíʹÓÃSessionµÄ¡£
¡¡¡¡·ÏÂÒ»¸ö½«Ö´Ðеķ½·¨ÊÇAddParsedSubObject·½·¨£¬Õâ¸ö·½·¨½«Ìí¼ÓËùÓжÀÁ¢µÄ¿Ø¼þ²¢°ÑÒ³Ãæ×é³ÉÒ»¸ö¿Ø¼þ¼¯ºÏÊ÷£¬Õâ¸ö·½·¨¾³£±»Ò»Ð©¸ß¼¶µÄÒ³ÃæÄ£°å½â¾ö·½°¸(Page Template Solutions)ÖØÐ´ÒÔ±ãÌí¼ÓÒ³ÃæÄÚÈݵ½Ò³ÃæÄ£°å(Page Template)ÖÐÒ»Ð©ÌØÊâµÄ¿Ø¼þÖС£Õâ¸ö·½·¨µÝ¹éÓ¦Óõ½ËùÓеÄÒ³Ãæ¿Ø¼þ¼°ÏàÓ¦µÄµÄÿ¸ö×ӿؼþ£¬ËùÓеĿؼþ¶¼ÊÇÔÚÕâ¸ö·½·¨ÖпªÊ¼×îÔçµÄ³õʼ»¯¡£
¡¡¡¡·Ò³ÃæÀàÖÐÏÂÒ»¸ö½«Ö´Ðеķ½·¨ÊÇDeterminePostBackMode¡£Õâ¸ö·½·¨ÔÊÐíÄúÐÞ¸ÄIsPostBackµÄÖµ¼°Ïà¹ØµÄʼþ¡£Èç¹ûÄúÐèÒª´ÓÊý¾Ý¿âÖмÓÔØViewStateÕâ¸ö·½·¨½«ÌرðÓÐÓã¬ÒòΪViewStateÖ»ÓÐÔÚIsPostBackÎªÕæµÄÇé¿öÏÂ²Å»á½øÐлָ´¡£·µ»Ø¿Õ½«»áµ¼ÖÂÇ¿ÖÆÖ´Ðзǻش«£¬·µ»ØRequest.FormÔòÇ¿ÖÆÖ´ÐÐÒ»¸ö»Ø´«¡£³ý·ÇÔÚÌØÊâÇé¿öÏ ......
Ê×ÏÈÒªÌí¼Ó
using System.Data;
using System.Data.SqlClient;
½ÓÏÂÀ´£º
SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=£¨ÄãµÄÃÜÂ룩;database=£¨ÄãµÄÊý¾Ý±í£©"); //ÓÃÓÚÁ¬½ÓÊý¾Ý¿â
conn.Open(); //´ò¿ªÊý¾Ý¿â
SqlCommand cmd = new SqlCommand("select * from [user]", conn); //Ï൱ÓÚÖ´ÐÐÊý¾ÝÓï¾ä°É
SqlDataReader read = cmd.ExecuteReader(); &nb ......
Ê×ÏÈÒªÌí¼Ó
using System.Data;
using System.Data.SqlClient;
½ÓÏÂÀ´£º
SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=£¨ÄãµÄÃÜÂ룩;database=£¨ÄãµÄÊý¾Ý±í£©"); //ÓÃÓÚÁ¬½ÓÊý¾Ý¿â
conn.Open(); //´ò¿ªÊý¾Ý¿â
SqlCommand cmd = new SqlCommand("select * from [user]", conn); //Ï൱ÓÚÖ´ÐÐÊý¾ÝÓï¾ä°É
SqlDataReader read = cmd.ExecuteReader(); &nb ......
Æô¶¯Ò³Ã滺´æ£¬´úÂëÈçÏ£º
<%OutputCache Duration="60" VaryByParam="*"%>
˵Ã÷£º
Duration±ØÐèÊôÐÔ¡£Ò³Ãæ±»»º´æºµ£¬ÒÔÃëΪµ¥Î»£¬ÇÒ±ØÐëÊÇÕûÊý¡£
Location Ö¸¶¨Ó¦Êä³ö½øÐлº´æµÄλÖᣲÎÊýÊÇÒÔÏÂÑ¡ÏîÖ®Ò»£ºAny,Client,Downstream,None,Server,ServerAndClient
VaryByParam ±ØÐèÊôÐÔ¡£RequestÖбäÁ¿µÄÃû³Æ£¬ÕâЩ±äÁ¿ÃûÓ¦¸Ã²úÉúµ¥¶ÀµÄ»º´æÌõÄ¿¡£“none”±íʾûÓб䶯¡£“*”¿ÉÓÃÓÚΪÿ¸ö²»Í¬µÄ±äÁ¿Êý×é´´½¨ÐµĻº´æÌõÄ¿¡£±äÁ¿Ö®¼äÓÓ£»”½øÐзָô¡£
VaryByHeader»ùÓÚÖ¸¶¨µÄÖеı䶯¸Ä±ä»º´æÌõÄ¿¡£
VaryByCustomÔÊÐíÔÚglobal.asaxÖÐÖ¸¶¨×Ô¶¨Òå±ä¶¯£¨Àý£º“Browser”£©
²úƷĿ¼ÔÊÐíÓû§»ùÓÚcategoryIDºÍÒ³±äÁ¿²é¿´Ä¿Â¼Ò³£¬¿ÉÒÔÓÃVaryByParam="categoryID;page", ½«²úƷĿ¼»º´æÒ»¶Îʱ¼ä£¨Èç¹û²úÆ·²»ÊÇËæÊ±¶¼Ôڸı䣬һСʱ»¹ÊÇ¿ÉÒÔ½ÓÊܵģ¬Òò´Ë£¬³ÖÐøÊ±¼äÊÇ3600Ã룩¡£Õ⽫Ϊÿ¸öÖÖÀàµÄÿ¸öĿ¼ҳ´´½¨µ¥¶ÀµÄ»º´æÌõÄ¿¡£Ã¿¸öÌõÄ¿´ÓÆäµÚÒ»¸öÇëÇóËãÆð½«Î¬³ÖÒ»¸öСʱ¡£
VaryByHeader ºÍVaryByCustomÖ÷ÒªÓÃÓÚ¸ù¾Ý·ÃÎÊÒ³ÃæµÄ¿Í»§¶Ë¶ÔÒ³ÃæµÄÍâ¹Û»òÄÚÈݽøÐÐ×Ô¶¨Ò塣ͬһ¸öURL¿ÉÄÜÐèҪͬʱΪä¯ÀÀÆ÷ºÍÒÆ ......
ÎÒÓÃC# дµÄÒ»¸öWindowsÓ¦ÓóÌÐòÀï,ÓÃTeeChartʵÏÖÁËÒ»¸öÕÛÏßͼ.
XÖáÊÇʱ¼ä,YÖáÊÇÊýÖµ,¼ÓÁ˸öÒ»´¹Ö±µÄCursorTool.
Êó±êÔÚͼÉÏÒÆ¶¯Ê±,´¹Ö±µÄCursorTool»á¸ú×ÅÊó±êÅÜ,²¢´¥·¢CursorToolµÄChangeʼþ.
ÔÚCursorToolµÄChangeʼþÀï,
ÎÒÈ¡³öÁËÇúÏßÓë´¹Ö±µÄÏß½»µã´¦µÄ,ʱ¼äÖµ,ºÍÊýÖµ.
ÎÒдÕâ¸öWindow³ÌÐòµÄÖ÷ÒªÉϵÄÊÇÃþË÷TeeChartµÄÓ÷¨,×îÖÕÒª½«ÆäÔÚasp.netÀïʵÏÖ.
µ«ÔÚasp.netÀïʵÏÖʱ,Óöµ½ÁËÂé·³.
ÇúÏßÄܳöÀ´,´¹Ö±µÄÏßÒ²ÄÜ¿´µ½
µ«Êó±êÒÆ¶¯Ê±,´¹Ïß²»¸ú×ÅÅÜÁË,Ò²²»´¥·¢Changeʼþ
Çë¸÷λ¸ßÊÖ°ïÎÒ·ÖÎöÒ»ÏÂÊÇʲôÔÒò
²»ÖªµÀÓÐûÓÐÈËÓöµ½ÀàËÆµÄÎÊÌâ.
»òÕßÓÐûÓÐʲôÆäËü·½·¨,ÄÜʵÏÖÕâÑùµÄ¹¦ÄÜ? ......
asp.net±ÏÒµÉè¼Æ¾ÍÊÇÓÃC#ÓïÑÔ¿ª·¢µÄWEBµÄ±ÏÒµÉè¼Æ£¬ÏÖÔںöà´óѧ¶¼Ñ¡ÔñÓÃasp.netÀ´×ö±ÏÒµÉè¼Æ£¬±¾Õ¾¿ªÊ¼×ö±ÏÒµÉè¼Æ¾ÍÑ¡ÔñÁËasp.net¿ª·¢±ÏÒµÉè¼Æ±ðµÄÉè¼Æ²»×ö¡£
¶¨×öasp.net±ÏÒµÂÛÎÄרÏߣº
±à³ÌÁªÃËÕ¾³¤
QQ£º153933864 êdzƣºÐÇÆÚ°Ë
ÁõÏÈÉú£ºÊÖ»ú£º13733310210
ÎÒÃǵÄasp.net±ÏÒµÉè¼Æ³ÉÆ·Ö÷Òª²¿·ÖÔÚÏÂÃæÁгö£º
±¾Õ¾ÒÔ¶¨×öΪÖ÷¡£ÒòΪ±ÏÒµÉè¼Æ³ÉÆ·»áÉæ¼°µ½Öظ´³Ï®µÈµÈÎÊÌâʹÄú²»ÄÜ˳Àû±ÏÒµ¡£ËùÒÔÎÒÃÇÖ÷ÒªÊǸù¾ÝÄúµÄÐèÇó½øÐж¨×ö,ÕâÑù³öÀ´µÄasp.net±ÏÒµÉè¼Æ±£Ö¤¶ÀÒ»ÎÞ¶þ²»»á³Ï®ºÍÖØ¸´¡£Ê¹ÄúÄÜ˳Àû±ÏÒµ¡£ ......