ËäȻ˵ASP.NETÊôÓÚ°²È«ÐԸߵĽű¾ÓïÑÔ,µ«ÊÇÒ²¾³£¿´µ½ASP.NETÍøÕ¾ÓÉÓÚ¹ýÂ˲»ÑÏÔì³É×¢Éä.ÓÉÓÚASP.NET»ù±¾ÉÏÅäºÏMMSQLÊý¾Ý¿â¼ÜÉè Èç¹ûȨÏÞ¹ý´óµÄ»°ºÜÈÝÒ×±»¹¥»÷. ÔÙÕßÔÚÍøÂçÉÏÕÒ²»µ½ºÃµÄASP.NET·À×¢Éä½Å±¾,ËùÒÔ¾Í×Ô¼ºÐ´Á˸ö. ÔÚÕâÀï¹²Ïí³öÀ´Ö¼ÔÚÈóÌÐòÔ±Ãâ³ýSQL×¢ÈëµÄÀ§ÈÅ.
ÎÒдÁËÁ½¸ö°æ±¾,VB.NETºÍC#°æ±¾·½±ã²»Í¬³ÌÐò¼äʹÓÃ.
°Ù¶ÈÏÂÔØµØÖ·:
http://www.baidu.com/s?bs=ASP.NET%B7%C0SQL%D7%A2%C8%EB%BD%C5%B1%BE%B3%CC%D0%F2+v2.0+chinaz&f=8&wd=ASP.NET%B7%C0SQL%D7%A2%C8%EB%BD%C5%B1%BE%B3%CC%D0%F2+v2.0+
google ÏÂÔØµØÖ·:
http://www.google.cn/search?hl=zh-CN&source=hp&q=ASP.NET%E9%98%B2SQL%E6%B3%A8%E5%85%A5%E8%84%9A%E6%9C%AC%E7%A8%8B%E5%BA%8F+v2.0&btnG=Google+%E6%90%9C%E7%B4%A2&aq=f&oq=
Bing ÏÂÔØµØÖ·:
http://cn.bing.com/search?q=ASP.NET%E9%98%B2SQL%E6%B3%A8%E5%85%A5%E8%84%9A%E6%9C%AC%E7%A8%8B%E5%BA%8F+v2.0&go=&form=QBLH&filt=all ......
ËäȻ˵ASP.NETÊôÓÚ°²È«ÐԸߵĽű¾ÓïÑÔ,µ«ÊÇÒ²¾³£¿´µ½ASP.NETÍøÕ¾ÓÉÓÚ¹ýÂ˲»ÑÏÔì³É×¢Éä.ÓÉÓÚASP.NET»ù±¾ÉÏÅäºÏMMSQLÊý¾Ý¿â¼ÜÉè Èç¹ûȨÏÞ¹ý´óµÄ»°ºÜÈÝÒ×±»¹¥»÷. ÔÙÕßÔÚÍøÂçÉÏÕÒ²»µ½ºÃµÄASP.NET·À×¢Éä½Å±¾,ËùÒÔ¾Í×Ô¼ºÐ´Á˸ö. ÔÚÕâÀï¹²Ïí³öÀ´Ö¼ÔÚÈóÌÐòÔ±Ãâ³ýSQL×¢ÈëµÄÀ§ÈÅ.
ÎÒдÁËÁ½¸ö°æ±¾,VB.NETºÍC#°æ±¾·½±ã²»Í¬³ÌÐò¼äʹÓÃ.
°Ù¶ÈÏÂÔØµØÖ·:
http://www.baidu.com/s?bs=ASP.NET%B7%C0SQL%D7%A2%C8%EB%BD%C5%B1%BE%B3%CC%D0%F2+v2.0+chinaz&f=8&wd=ASP.NET%B7%C0SQL%D7%A2%C8%EB%BD%C5%B1%BE%B3%CC%D0%F2+v2.0+
google ÏÂÔØµØÖ·:
http://www.google.cn/search?hl=zh-CN&source=hp&q=ASP.NET%E9%98%B2SQL%E6%B3%A8%E5%85%A5%E8%84%9A%E6%9C%AC%E7%A8%8B%E5%BA%8F+v2.0&btnG=Google+%E6%90%9C%E7%B4%A2&aq=f&oq=
Bing ÏÂÔØµØÖ·:
http://cn.bing.com/search?q=ASP.NET%E9%98%B2SQL%E6%B3%A8%E5%85%A5%E8%84%9A%E6%9C%AC%E7%A8%8B%E5%BA%8F+v2.0&go=&form=QBLH&filt=all ......
Stephen Walther
Superexpert
ÊÊÓÃÓÚ£º
Microsoft ASP.NET 2.0
Microsoft Visual Studio 2005
¼ò½é
ÔÚ Microsoft ASP.NET 2.0 Framework ÖУ¬Êý¾Ý¿â·ÃÎʵõ½Á˼«´óµÄ¼ò»¯¡£ÀûÓÃÈ«Ð嵀 SqlDataSource ¿Ø¼þ£¬ÄúÎÞÐè±àдһÐдúÂë¾Í¿ÉÒÔÑ¡Ôñ¡¢¸üС¢²åÈëºÍɾ³ýÊý¾Ý¿âÊý¾Ý¡£
Éú³É¼òµ¥µÄÓ¦ÓóÌÐòʱ£¬SqlDataSource ¿Ø¼þÊÇÒ»¸öºÜºÃµÄÑ¡Ôñ¡£Èç¹ûÄúÐèҪѸËÙÉú³ÉÒ»¸öʹÓû§¿ÉÒÔÏÔʾºÍ±à¼Êý¾Ý¿â¼Ç¼µÄ Web Ò³£¬Ê¹Óà SqlDataSource ¿Ø¼þÔÚ¼¸·ÖÖÓÖ®ÄÚ¾ÍÄÜÍê³É´Ë¹¤×÷¡£
ÀýÈ磬ÎÒ×Ô¼º¾ÍÔø¼ÆÊ±Éú³ÉÁËÕâôһ¸öÒ³Ãæ¡£Í¨¹ý½áºÏʹÓà SqlDataSource ¿Ø¼þÓë GridView ¿Ø¼þ£¬ÎÒÔÚ 1 ·Ö 15Ãë ÄÚ¾ÍÄÜÉú³ÉÒ»¸öÓÃÓÚÏÔʾ Northwind Products Êý¾Ý¿â±íµÄÄÚÈݵÄÒ³Ãæ¡£¾ÍÓÐÕâô¿ì£¡
µ«ÊÇ£¬SqlDataSource ¿Ø¼þ´æÔÚÒ»¸öÎÊÌâ¡£Èç¹ûÄúʹÓà SqlDataSource ¿Ø¼þ£¬ÄÇÄú¾ÍÊÇÔÚ×ö²»Ì«ÃîµÄÊÂÇé¡£SqlDataSource ¿Ø¼þµÄȱµãÔÚÓÚËüÆÈʹÄú½«Óû§½çÃæ²ãÓëÒµÎñÂß¼²ã»ìºÏÔÚÒ»Æð¡£ÈκÎÓ¦ÓóÌÐò¼Ü¹¹Ê¦¶¼»á¸æËßÄú£º»ìºÏ¶à¸ö²ãµÄÐÐΪÊDz»¿ÉÈ¡µÄ¡£
Éú³ÉÑϸñÒâÒåÉϵĶà²ã Web Ó¦ÓóÌÐòʱ£¬ÄúÓ¦¸Ã¾ßÓÐÇåÎúµÄÓû§½çÃæ²ã¡¢ÒµÎñÂß¼²ãºÍÊý¾Ý·ÃÎʲ㡣½ö½öÓÉÓÚ SqlDataSource ¿Ø¼þµÄÇ¿ÖÆ¶øÔÚÓû§½çÃæ²ãÒýÓà SQL Óï¾ä»ò´æ ......
.ascx webÓû§¿Ø¼þ
.asmx web·þÎñ
.asax È«¾ÖÓ¦ÓóÌÐòÀà
.sitemap ÍøÕ¾µØÍ¼
.htm HTMLÒ³
.xml XMLÒ³
.master ĸ°æÒ³
.config webÅäÖÃÎļþ
.skin Íâ¹ÛÎļþ
.css Ñùʽ±íÎļþ ......
asp.netÖеÄhtml¿Ø¼þrunat=serverʱµÄÓ³Éä 1¡¢±ê×¼xhtml±êÇ©£ºhttp://blog.csdn.net/TangZhongxin/archive/2009/07/31/4398487.aspx 2¡¢¾ø´ó¶àÊý±êÇ©¶¼Ó³Éäµ½¡°System.Web.UI.HtmlControls.HtmlGenericControl¡±£¬ËüÃǵĹ²Í¬ÌØÐÔÊÇ¡°ÐÅÏ¢Ö»¶Á£¬½ö¹©ÏÔʾµÄ±ê¼Ç¡±£º
div,span,p,h1,h2,h3,h4,h5,h6,ul,li,dl,dt,dd,
abbr,acronym,address,bdo,blockquote,pre,br,q,ins,del,sub,sup,hr,map,area,
optgroup,label,fieldset,legent,
em,strong,dfn,code,samp,kbd,var,cite,
tt,i,b,big,small,
colgroup,col,caption,thead,tbody,tfoot,
param,
title,base,link,meta,style, 3¡¢Á´½ÓºÍͼÏñ¡¢¶ÔÏóÀà±êÇ©
±êÇ©a£¬Ó³Éäµ½ System.Web.UI.HtmlControls.HtmlAnchor £»
±êÇ©img£¬Ó³Éäµ½ System.Web.UI.HtmlControls.HtmlImage £»
±êÇ©object£¬²»ÄÜÓ³É䣻
±êÇ©param£¬Ó³Éäµ½ System.Web.UI.HtmlControls.HtmlGenericControl£» 4¡¢form±íµ¥Àà±êÇ©£º form System.Web.UI.HtmlControls.HtmlForm input type="text" System.Web.U ......
ûÓÐÏëµ½ÕæµÄÕâô·½±ã!¸ü¼Ó¼á¶¨ÎÒѧϰASP.NETµÄ¾öÐÄ! ÏÖÔÚÎÒÃÇÒ»ÆðÀ´¿´¿´°É
1,ÇëÈ·¶¨ÄãµÄµçÄÔ°²×°ÁËÒÔϵÄÈí¼þ£¡
1.1£¬ WINDWOS 2000ÒÔÉϰ汾(±Ø×°)
1.2£¬ .NET Framework(±Ø×°)
1.3£¬ Visual Studio .NET 2005(±Ø×°)
2,½¨Á¢Ò»¸öACCESSÊý¾Ý¿â,
3,Í϶¯VS2005 µÄGRIDVIEW µ½Éè¼ÆÒ³Ãæ
4.¸ÄÔ´´úÂë
4.1 ÔÚASPX´úÂëÎļþµÄÍ·²¿£¬Ìí¼Ó²Ù×÷Êý¾Ý¿âÒªÓõ½µÄÃüÃû¿Õ¼ä£º
using System.Data.OleDb;
4.2 ÔÚaspxµÄ[Éè¼Æ]ÊÓͼÖУ¬ÉùÃ÷³ÉÔ±myConnection£º
[¸´ÖƵ½¼ôÌù°å]
CODE:
protected OleDbConnection myConnection=new OleDbConnection ();
4.3 µÚÒ»²½£¬½øÐÐÊý¾Ý¿âµÄÁ´½Ó
[¸´ÖƵ½¼ôÌù°å]
CODE:
string strConn= "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("SOCUT.mdb");
OleDbConnection myConnection=new OleDbConnection ();
myConnection.ConnectionString =strConn;
µÚ¶þ²½£¬Ö´ÐÐSQLÖ¸Áѡ³ö¼Ç¼¼¯ºÏ
[¸´ÖƵ½¼ôÌ ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕâÁ½¸öµ«Êdz£ÓõÄÓïÑÔ¶àÁËÒ»¸öC#£¬Ò²ÊÇ΢ÈíÍÆ¼öµÄÓïÑÔ£¬Îª.NETƽ̨¶¨ÖƵÄÓïÑÔ¡£ÕâÑùASP.NET¾ÍÓÐËÄÖÖ×éºÏ£ºVB+ACCESS£¬VB+SQL£¬C#+ACCESS£¬C#+SQL£¬±¾½Ì³Ì»áʹÓÃC#+ACCESS£¬¼æ¹ËËÄÖÖÀ´Ð´£¬Èôó¼Ò¶ÔASP.NETÓÐÒ»¸öÈ«ÃæµÄÈÏʶ¡£ËäȻ˵ѧϰASP.NET²»ÐèÒªÈκÎASP»ù´¡£¬µ«ÊÇÎÒ¾õµÃÈç¹û´ó¼ÒASP²»»á£¬»¹ÊÇÏÈ¿´Ò»Ï¡¾Ê®Ììѧ»áASP½Ì³Ì¡¿£¬´ó¼ÒËùÐèÒªÁ˽âµÄ²»ÊÇASPµÄ³ÌÐòÔõôд£¬¶øÊÇÔõô¹¹½¨·þÎñÆ÷£¬ÔõôʹÓÃHTML±íµ¥£¬Í¬Ê±¶ÔSQLÓï¾äÓÐÒ»¸ö»ù´¡ºÍÀí½â£¬ÒòΪÔÚ±¾ÎÄÀïÎÒ²»»á½«½«Ò»Ð©»ù´¡µÄ¶«Î÷¡£
·Ï»°²»¶à˵£¬¿ªÊ¼ÎÒÃǵÚÒ»ÌìµÄѧϰ£º
ѧϰĿµÄ£ºµ÷ÊÔ³ö°²×°»·¾³
ÎÒÒªÉêÃ÷Ò»µã£¬²Ù×÷ϵͳ¾ÍÓÃ2000£¬Èç¹û˵Ҫѧϰһ¸öÍøÂçÓïÑÔ»¹²»¿Ï¶à×°Ò»¸ö²Ù×÷ϵͳµÄ»°£¬ÄÇÎÒ¿´Ò²²»ÒªÑ§Ï°ÁË¡£
Ïȵ½ÍøÉÏÏÂÔØÒ»¸öMDAC(ÒªÊÇ2.7ÒÔÉϵİ汾²ÅÐÐ)£¬È»ºó°²×°£¬ ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕâÁ½¸öµ«Êdz£ÓõÄÓïÑÔ¶àÁËÒ»¸öC#£¬Ò²ÊÇ΢ÈíÍÆ¼öµÄÓïÑÔ£¬Îª.NETƽ̨¶¨ÖƵÄÓïÑÔ¡£ÕâÑùASP.NET¾ÍÓÐËÄÖÖ×éºÏ£ºVB+ACCESS£¬VB+SQL£¬C#+ACCESS£¬C#+SQL£¬±¾½Ì³Ì»áʹÓÃC#+ACCESS£¬¼æ¹ËËÄÖÖÀ´Ð´£¬Èôó¼Ò¶ÔASP.NETÓÐÒ»¸öÈ«ÃæµÄÈÏʶ¡£ËäȻ˵ѧϰASP.NET²»ÐèÒªÈκÎASP»ù´¡£¬µ«ÊÇÎÒ¾õµÃÈç¹û´ó¼ÒASP²»»á£¬»¹ÊÇÏÈ¿´Ò»Ï¡¾Ê®Ììѧ»áASP½Ì³Ì¡¿£¬´ó¼ÒËùÐèÒªÁ˽âµÄ²»ÊÇASPµÄ³ÌÐòÔõôд£¬¶øÊÇÔõô¹¹½¨·þÎñÆ÷£¬ÔõôʹÓÃHTML±íµ¥£¬Í¬Ê±¶ÔSQLÓï¾äÓÐÒ»¸ö»ù´¡ºÍÀí½â£¬ÒòΪÔÚ±¾ÎÄÀïÎÒ²»»á½«½«Ò»Ð©»ù´¡µÄ¶«Î÷¡£
·Ï»°²»¶à˵£¬¿ªÊ¼ÎÒÃǵÚÒ»ÌìµÄѧϰ£º
ѧϰĿµÄ£ºµ÷ÊÔ³ö°²×°»·¾³
ÎÒÒªÉêÃ÷Ò»µã£¬²Ù×÷ϵͳ¾ÍÓÃ2000£¬Èç¹û˵Ҫѧϰһ¸öÍøÂçÓïÑÔ»¹²»¿Ï¶à×°Ò»¸ö²Ù×÷ϵͳµÄ»°£¬ÄÇÎÒ¿´Ò²²»ÒªÑ§Ï°ÁË¡£
Ïȵ½ÍøÉÏÏÂÔØÒ»¸öMDAC(ÒªÊÇ2.7ÒÔÉϵİ汾²ÅÐÐ)£¬È»ºó°²×°£¬ ......
Ê®Ììѧ»áASP.net֮ʵսϵÁУ¨C#ºÍVb.netË«°æ±¾£©
µÚÒ»Ìì
ÎÒÈÏΪASP.NET±ÈASPÄѺܶ࣬ϣÍû´ó¼Ò×öºÃ×¼±¸¡£ÄÑÄÑÔÚʵÏÖͬһ¸öЧ¹ûÓкܶ෽·¨£¬´ó¼Ò»òÐí»áÒÉ»ó¡£Ê®Ììѧ»áϵÁн̳̻áÇåÎúµÄд³ö¸÷ÖÖ·½·¨£¬Èôó¼ÒÄÜÉÙÒ»µã¿²¿À¡£ÔÚASPÀïÃæ£¬´ó¼Ò¼¸ºõ¶¼ÊÇʹÓÃVB£¬Êý¾Ý¿âÂҲÎÞ·ÇÊÇSQLºÍACCESS¡£ÔÚASP.NETÀïÃæ£¬Êý¾Ý¿â»¹ÊÇÕâÁ½¸öµ«Êdz£ÓõÄÓïÑÔ¶àÁËÒ»¸öC#£¬Ò²ÊÇ΢ÈíÍÆ¼öµÄÓïÑÔ£¬Îª.NETƽ̨¶¨ÖƵÄÓïÑÔ¡£ÕâÑùASP.NET¾ÍÓÐËÄÖÖ×éºÏ£ºVB+ACCESS£¬VB+SQL£¬C#+ACCESS£¬C#+SQL£¬±¾½Ì³Ì»áʹÓÃC#+ACCESS£¬¼æ¹ËËÄÖÖÀ´Ð´£¬Èôó¼Ò¶ÔASP.NETÓÐÒ»¸öÈ«ÃæµÄÈÏʶ¡£ËäȻ˵ѧϰASP.NET²»ÐèÒªÈκÎASP»ù´¡£¬µ«ÊÇÎÒ¾õµÃÈç¹û´ó¼ÒASP²»»á£¬»¹ÊÇÏÈ¿´Ò»Ï¡¾Ê®Ììѧ»áASP½Ì³Ì¡¿£¬´ó¼ÒËùÐèÒªÁ˽âµÄ²»ÊÇASPµÄ³ÌÐòÔõôд£¬¶øÊÇÔõô¹¹½¨·þÎñÆ÷£¬ÔõôʹÓÃHTML±íµ¥£¬Í¬Ê±¶ÔSQLÓï¾äÓÐÒ»¸ö»ù´¡ºÍÀí½â£¬ÒòΪÔÚ±¾ÎÄÀïÎÒ²»»á½«½«Ò»Ð©»ù´¡µÄ¶«Î÷¡£
·Ï»°²»¶à˵£¬¿ªÊ¼ÎÒÃǵÚÒ»ÌìµÄѧϰ£º
ѧϰĿµÄ£ºµ÷ÊÔ³ö°²×°»·¾³
ÎÒÒªÉêÃ÷Ò»µã£¬²Ù×÷ϵͳ¾ÍÓÃ2000£¬Èç¹û˵Ҫѧϰһ¸öÍøÂçÓïÑÔ»¹²»¿Ï¶à×°Ò»¸ö²Ù×÷ϵͳµÄ»°£¬ÄÇÎÒ¿´Ò²²»ÒªÑ§Ï°ÁË¡£
Ïȵ½ÍøÉÏÏÂÔØÒ»¸öMDAC(ÒªÊÇ2.7ÒÔÉϵİ汾²ÅÐÐ)£¬È»ºó°²×°£¬ ......