ASP.NETѧϰ±Ê¼ÇÁù ´î½¨¡°µÚÈý²¨Êéµê¡±ÏµÍ³¿ò¼Ü
Ò»°ã´î½¨Èý²ã¿ò¼ÜÏîÄ¿ÊÇÕâÑùµÄ:
1¡¢´´½¨Ò»¸ö¿ÕµÄ½â¾ö·½°¸
2¡¢´´½¨Àà¿âÏîÄ¿
3¡¢´´½¨ÍøÕ¾ÏîÄ¿
4¡¢Ìí¼ÓÏîĿ֮¼äµÄÒýÓã¬ÐèҪעÒâµÄÊDZíʾ²ã£¨ÍøÕ¾ÏîÄ¿²ã£©ÊDz»ÐèÒªÌí¼ÓÆäËü²ãÒýÓõģ¬ÒòΪÔËÐк󣬻á×Ô¶¯²úÉú¶ÔÆäËüÏîÄ¿µÄÒýÓÃ
Èý²ã½á¹¹£º
Êý¾Ý·ÃÎʲ㣺Ö÷ҪʵÏÖÊý¾ÝµÄ±£´æºÍ¶ÁÈ¡²Ù×÷¡£
ÒµÎñÂß¼²ã£º³ýÁ˰üº¬ÒµÎñÂß¼Í⣬»¹×÷Ϊ±íʾ²ãºÍÊý¾Ý·ÃÎʲãÖ®¼äͨÐŵÄÇÅÁº£¬¸ºÔðÊý¾ÝµÄ´«µÝºÍ´¦Àí¡£
±íʾ²ã£»ÓÃÓÚÏÔʾÊý¾ÝºÍ½ÓÊÕÓû§ÊäÈëµÄÊý¾Ý£¬ÎªÓû§ÌṩһÖÖ½»»¥Ê½²Ù×÷½çÃæ¡£
Èý²ã½á¹¹µÄÓÅÊÆ£º
ÊÊÓ¦±ä»¯£¬ÀûÓÚά»¤¡£
ÊÊÓÃÓÚÐ×÷¿ª·¢¡£
Ö÷Á÷Ç÷ÊÆ¡£
Ä£ÐͲ㣺
Ä£ÐͲã°üº¬ËùÓÐÓëÊý¾Ý¿âÖеıíÏà¶ÔÓ¦µÄʵÌåÀࡣģÐͲãÌṩÁËÒ»¸ö±ê×¼¹æ·¶£¬Èý²ãÖ®¼äµÄÊý¾Ý´«µÝ¾ÍÊÇͨ¹ý´«ÊäʵÌå¶ÔÏóÀ´´ïµ½Ä¿µÄ¡£ Ò»°ãÄ£ÐͲãµÄÏîÄ¿Ãû³ÆÎªModel»òÕßModels£¬Ò²¿ÉÒÔÊǽâ¾ö·½°¸Ãû+.Models£¬Ä£ÐͲãÖеÄʵÌåÀàÒ»°ãºÍËù¶ÔÓ¦µÄ±íÃûÒ»Ö¡£
Èç¹û±íÃûÒÔ“s”½áβ£¬ÊµÌåÀàÒ»°ã»áÒÔµ¥ÊýÐÎʽ±íʾ¡£
ʵÌåÀà¸ù¾ÝÊý¾Ý¿âÖеÄ×ֶαàд¶ÔÓ¦µÄ±äÁ¿ºÍÊôÐÔ£¬²¢±ê¼ÇΪ¿ÉÐòÁл¯¡£´¦ÀíÍâ¼üʱʱ¿ÉÒÔʹÓÃÍâ¼ü±íµÄID»òÕßʹÓÃÍâ¼ü¶ÔÏó¡£
Êý¾Ý·ÃÎʲ㣺
Êý¾Ý·ÃÎʲã·â×°ÁËËùÓÐÓëÊý¾Ý¿â½»»¥µÄ²Ù×÷¡£
Êý¾Ý·ÃÎʲãÏîĿһ°ãÃüÃûΪDAL£¬»ò½â¾ö·½°¸Ãû+DAL¡£Õë¶ÔÄ£ÐͲãÖеÄÿһ¸öÀ࣬Êý¾Ý·ÃÎʲãÓÐÒ»¸ö¶ÔÓ¦µÄÊý¾Ý·ÃÎÊÀà¡£
Êý¾Ý·ÃÎʲãµÄÀàºÍ·½·¨Ò»°ã¶¼ÊǾ²Ì¬µÄ¡£ÐèÒªSQLÓï¾ä×÷Ϊ²ÎÊýµÄ·½·¨£¬Ó¦½«Æä·ÃÎÊÐÞÊηûÉèΪprivate£¬ÒÔʹÆä²»ÄÜÔÚÒµÎñ·ÃÎʲãÖб»µ÷Óá£
connection.State==System.Data.ConnectionState.Closed;//ÅжÏÊý¾Ý¿âÁ¬½ÓÊÇ·ñ¹Ø±Õ
connection.State==System.Date.ConnectionState.Broken;//ÅжÏÊÇ
Ïà¹ØÎĵµ£º
£¼input id = " loFile " type = " file " runat = " server " £¾
£¼form method = " post " enctype =" multipart/form-data " runat = " server "£¾
£¼/form £¾
1.»ñµÃÉÏ´«ÎļþµÄÃû³Æ£º£¨¹Ø¼üÊÇPostedFileÀàµÄÓ¦Óã©
ʹÓÃPathÀàÖеÄGetFileName·½·¨£¬¾ßÌåÈçÏ£º
lstrFileName = loFile.PostedFile.FileName ......
Ê×ÏÈÔÚ Web.Config ÖÐÌí¼ÓÄ£ÄâÕʺÅ
<identity impersonate="true" userName="administrator"password="password" />
Æä´Î ÒªÌí¼Ó EXCEL com ×é¼þ¡£Èç¹ûÊÇEXCEL2003,ÔòÌí¼Ó EXcel library 11.0 ......
×î½ü·¢ÏÖÓïÒôÑéÖ¤ÂëÔ½À´Ô½Á÷ÐУ¬±ÈÈçÓдÎÔÚ×¢²ágmailÓÊÏä¿´µ½¹ý£¬»¹ÓÐmsnÒ³ÃæÒ²ÓÐÓïÒôÑéÖ¤Â룬»¹ÓйúÍâÒ»Ð©ÍøÕ¾µÈ¡£
»¨Ê±¼äÑо¿ÁËÏ£¬ÓïÒôÑéÖ¤ÂëÖ÷Òª¸úÒ»°ãÑéÖ¤ÂëµÄÇø±ð¾ÍÔÚÓÚÈçºÎÈÃÑéÖ¤Âë²¥·Å¡£±¾ÎÄÓïÒôÑéÖ¤ÂëÔÀí£º´Ó·þÎñÆ÷Éú³ÉÑéÖ¤Â룬
²¢±£´æµ½cookieÖУ¨getcode.aspx.cs£©,µ±µãÊÕÌýÑéÖ¤ÂëµÄʱºò£¬µ÷ÓÃjavascirpt²Ù×÷ ......
1.Á¬½ÓÊý¾Ý¿âÎļþ
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
SqlConnectionStringBuilderʵÀý»¯Ê±£¬ÒªÓõ½connectionString£¬È磺SqlConnectionStringBuild builder = new SqlC ......
ʹÓà SqlDataSource ¿Ø¼þÖ»ÐèºÜÉٵĴúÂë»òÎÞÐèÈκδúÂë¼´¿É´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£SqlDataSource ¿Ø¼þ¿ÉÓÃÓÚÈκξßÓйØÁª ADO.NET Ìṩ³ÌÐò£¨ÔÚÅäÖÃÎļþµÄ DbProviderFactories ½ÚÖÐÅäÖ㩵ÄÊý¾Ý¿â£¬°üÀ¨ Microsoft SQL Server¡¢Oracle¡¢ODBC »ò OLE DB Êý¾Ý¿â£¨Èç Microsoft Access£©¡£ÄúÔÚÅäÖÃʱָ¶¨ SqlDataSource ʹÓõ ......