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
Ïà¹ØÎĵµ£º
ÎÊÌâÒ»£º¼ò»¯°æWindows XPÉϰ²×°IIS5.1²½Öè
¼ò»¯°æXP²Ù×÷ϵͳµÄ“¿ØÖÆÃæ°å-->Ìí¼Ó/ɾ³ý³ÌÐò-->Ìí¼Ó/ɾ³ýWindows×é¼þ”ÖÐûÓГInternetÐÅÏ¢·þÎñ£¨IIS£©”Õâ¸ö°²×°Ñ¡ÏÓÚÊÇ×è°ÁËIISµÄÕý³£°²×°£¬Í¨¹ýÒ»·¬ÍøÉϲéÔÄ£¬ÖÕÓÚÕÒµ½Á˽â¾ö·½·¨£¬Æäʵ¿ÉÒÔ°´ÕÕÈçϲ½Öè½â¾ö£º
£¨Ò»£©Ê×ÏÈÔÚ“¿ªÊ¼&r ......
ASP.NET³ÌÐòÖг£ÓõÄÈýÊ®ÈýÖÖ´úÂë
1. ´ò¿ªÐµĴ°¿Ú²¢´«ËͲÎÊý£º
¡¡¡¡´«ËͲÎÊý£º
response.write("£¼script£¾window.open(’*.aspx?id="+this.DropDownList1.SelectIndex+"&id1="+...+"’)£¼/script£¾")
¡¡¡¡½ÓÊÕ²ÎÊý£º
string a = Request.QueryString("id");
string& ......
1¡¢¿ØÖÆGridView¿Ø¼þÖÐÄÚÈݵĻ»ÐÐ
GridView1.Attributes.Add("style","word-break:keep-all;word-wrap:normal");//Õý³£»»ÐÐ
GridView1.Attributes.Add("style","word-break:break-all;word-wrap:break-word");//×Ô¶¯»»ÐÐ
2¡¢É¾³ýGridView¿Ø¼þÐÐÐÅÏ¢µ¯³öÈ·ÈÏÌáʾ¿ò
ÔÚGridViewµÄRowDataBound()ʼþÖÐÌ ......
´óѧÉú»î£¬ºÜÄÑ˵£¬¸÷ÖÖÌå»áºÍ×Ì棬ÒòÈ˶øÒì
´óѧѧϰ£¬¸üÄÑ˵£¬¸÷Öֳɼ¨ºÍϹ»ì£¬¸÷ÓÐǧÇï
ºÜ¶àʱºò×ÜÊÇÔÚÏ룬ÕâЩÄêÀ´µ½µ×ѧµ½ÁËʲô£¬×÷Ϊһ¸ö´óѧÉú£¬±ÈÆðÄÇЩÉç»áÉϵĻì»ìµ½µ×ÓÐʲôÓÅÊÆ¡£Ã»Óд𰸣¬ÖÁÉÙÏÖÔÚûÓÐ
ºÜ¶àʱºò¶Ôѧϰ³äÂúÏ£Íû£¬µ«Äǽö½öÖ»ÊÇÍ£ÁôÔÚÄÔº£Öеļƻ®£¬¼¸ºõûÓйýʵÏÖ¡£
´óѧµÄ»ù´¡¿ÎºÜÖØÒª£¬ ......