asp.netÖÐ'***\ASPNET' µÇ¼ʧ°ÜµÄÔÒòÓë½â¾ö°ì·¨
1¡¢Èç¹ûÕâÖÖÇé¿ö³öÏÖÔÚ±¾»ú£¬ÔòÔÚsql server µÄÆóÒµ¹ÜÀíÆ÷µÄ¿ØÖÆÌ¨Ä¿Â¼ÀïÑ¡ÔñÏàÓ¦µÄÊý¾Ý¿â£¬ÔÚÆäϵÄÓû§½ÚµãµãÓÒ¼üн¨Êý¾Ý¿âÓû§£¬½«***\ASPNETÓû§¼ÓÈ룬²¢¸³ÓèpublicȨÏÞ¡£
2¡¢Èç¹û³öÏÖÔÚÆäËûµÄµçÄÔ£¬Ôò¼ì²é ³ÌÐòÁ¬½ÓSQLServerµÄÁ¬½Ó×Ö·û´®ÊDz»ÊÇÓÃÁËwindows¼¯³ÉµÇ½£¬Ò»°ã³öÏÖ´ËÎÊÌâµÄ×´¿ö¶¼ÊÇÒòΪʹÓÃÁËwindows¼¯³ÉµÇ¼Ôì³ÉµÄ¡£´Ëʱ£¬Äã¿ÉÒԸijÉÓÃÊý¾Ý¿âÕʺźÍÃÜÂëµÇ¼£¬ÀýÈ磺server=localhost;uid=sa;pwd=xxxx;database=master¡£
3¡¢sql Á¬½Ó×Ö·ûÀïһЩ³£¼û¹Ø¼ü×ÖµÄ֪ʶ
Security Support Provider Interface
ÉèÖÃIntegrated SecurityΪ True µÄʱºò£¬Á¬½ÓÓï¾äÇ°ÃæµÄ UserID, PW ÊDz»Æð×÷Óõ쬼´²ÉÓÃwindowsÉí·ÝÑé֤ģʽ¡£
Ö»ÓÐÉèÖÃΪ False »òÊ¡ÂÔ¸ÃÏîµÄʱºò£¬²Å°´ÕÕ UserID, PW À´Á¬½Ó¡£
Integrated Security ¿ÉÒÔÉèÖÃΪ: True, false, yes, no £¬ÕâËĸöµÄÒâ˼ºÜÃ÷°×ÁË£¬»¹¿ÉÒÔÉèÖÃΪ£ºsspi £¬Ï൱ÓÚ True£¬½¨ÒéÓÃÕâ¸ö´úÌæ True¡£
initial catalogÓëdatabaseµÄÇø±ðÊÇʲô
Initial Catalog:
DataBase:
Á½ÕßûÓÐÈκÎÇø±ðÖ»ÊÇÃû³Æ²»Ò»Ñù£¬¾ÍºÃÏñÊÇÈËÀàµÄÕæÊµÐÕÃûÓëÔøÓÃÃûÒ»Ñù¡£¡£¶¼¿ÉÒÔ½ÐÄã¡£
********************************************
Integrated Security=SSPI Õâ¸ö±íʾÒÔµ±Ç°WINDOWSϵͳÓû§ÉíÈ¥µÇ¼SQL SERVER·þÎñÆ÷£¬Èç¹ûSQL SERVER·þÎñÆ÷²»Ö§³ÖÕâÖÖ·½Ê½µÇ¼ʱ£¬¾Í»á³ö´í¡£
Äã¿ÉÒÔʹÓÃSQL SERVERµÄÓû§ÃûºÍÃÜÂë½øÐеǼ£¬È磺
"Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=Êý¾Ý¿âÃû;Data Source=192.168.0.1;User ID=sa;Password=ÃÜÂë"
***************************************************
Integrated Security - »ò - Trusted_Connection 'false' µ±Îª false ʱ£¬½«ÔÚÁ¬½ÓÖÐÖ¸¶¨Óû§ ID ºÍÃÜÂë¡£µ±Îª true ʱ£¬½«Ê¹Óõ±Ç°µÄ Windows ÕÊ»§Æ¾¾Ý½øÐÐÉí·ÝÑéÖ¤¡£ ¿Éʶ±ðµÄֵΪ true¡¢false¡¢yes¡¢no ÒÔ¼°Óë true µÈЧµÄ sspi£¨Ç¿ÁÒÍÆ¼ö£©¡£
*************************************************
ADO.net ÖÐÊý¾Ý¿âÁ¬½Ó·½Ê½
S
Ïà¹ØÎĵµ£º
ÔÚASP.NET 2.0 WEÕ¾µãÉÏ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÔÚweb.configÎļþÖмÓÈëÏÂÃæµÄ½ÚµãÀ´Ö§³ÖÌõ¼þ±àÒë¡£
<compilers>
<compiler language="c#" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"
¡¡¡¡extension ......
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² ......
ÔÚ.Netƽ̨ϽøÐÐCSÈí¼þ¿ª·¢Ê±,ÎÒÃǾ³£Óöµ½ÒÔºó»¹ÒªÓõ½Ä³Ð©±äÁ¿ÉÏ´ÎÐ޸ĺóµÄÖµ,ΪÁ˼òµ¥Æð¼û,ºÜ¶àÈ˶¼Ï°¹ßÓÃstaticÀ´¶¨ÒåÕâЩ±äÁ¿,ÎÒÒ²ÊÇ¡£ÕâÑù·Ç³£·½±ã£¬ÏÂÒ»´Îµ÷ÓÃij¸öº¯Êýʱ¸Ã±äÁ¿ÈÔÈ»±£´æµÄÊÇ´¦Àí¹ýµÄÖµ£¬Ö±½ÓÄÃÀ´ÓþͿÉÒÔÁË¡£
ÏÖÔÚתÈëÁËBSÈí¼þ¿ª·¢£¬ÎÒÃǺÜ×ÔÈ»µØ»áÑØÓ ......
1. Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspxÖУº < %= ......