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
Ïà¹ØÎĵµ£º
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;
/// <summary>
/// Pub µÄժҪ˵Ã÷
/// </summa ......
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()ʼþÖÐÌ ......
http://hi.baidu.com/%E5%EB%B3%DF%C8%CB%C9%FA/blog/item/58a1540bbf0bb437b1351d9a.html
#region DataGridViewÊý¾ÝÏÔʾµ½Excel
/// <summary>
/// ´ò¿ªExcel²¢½«DataGridView¿Ø¼þÖÐÊý¾Ýµ¼³öµ½Excel
/// </summary>
/// <param name="dgv">DataGridView¶ÔÏó </param>
/// <param na ......
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;//ÒýÈëÃüÃû¿Õ¼ä ......
1. Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspxÖУº < %= ......