asp.net±¸·ÝÊý¾Ý¿â
Asp.Net ±¸·ÝºÍ»Ö¸´SQL SERVER Êý¾Ý¿â
ÎÒÃÇͨ³£±¸·ÝÊý¾Ý¿âʱ£¬ÐèÒªµÇ¼Êý¾Ý¿â·þÎñÆ÷È¥±¸·ÝºÍ»Ö¸´£¬ÕâÑùºÜ²»·½±ã£¬ÆäʵSQL SERVER×Ô´øµÄÃüÁî¿ÉÄÜÈÃÎÒÃǺܼòµ¥µØʵÏÖÔ¶³Ìͨ¹ýAsp.Net±¸·ÝºÍ»Ö¸´Êý¾Ý¿â¡£
BACKUP DATABASE '±»±¸·ÝµÄÊý¾Ý¿âÃû' TO DISK = '±¸·ÝÎļþ·¾¶';
ALTER DATABASE '±»»Ö¸´µÄÊý¾Ý¿âÃû' SET OFFLINE WITH ROOLBACK IMMEDIATE;
RESTORE DATABASE '±»»Ö¸´µÄÊý¾Ý¿âÃû' from DISK = '±¸·ÝÎļþ·¾¶';
ALTER DATABASE '±»»Ö¸´µÄÊý¾Ý¿âÃû' SET ONLINE WITH ROOLBACK IMMEDIATE;
¼òµ¥¼¸ÌõÃüÁî¾Í¿ÉÒÔÍê³ÉÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´£¬ÔÚAsp.NetÖУ¬¿ÉÒÔÏñµ÷ÓÃSqlÓï¾äÒ»Ñùµ÷ÓÃÕâËÄÌõÓï¾ä£¬ÇáÇáËÉËÉʵÏÖSQL SERVERÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´¡£
Àý×Ó(ÒÔNorthwindΪÀý)£º
1¡¢±¸·ÝNorthwindÊý¾Ý¿âµ½CÅ̸ùĿ¼Ï£¬ÒÔ'Northwind.bak'ΪÃû£º
BACKUP DATABASE 'Northwind' TO DISK = 'C:\Northwind.bak';
2¡¢»Ö¸´NorthwindÊý¾Ý¿â,CÅ̸ùĿ¼ÏµÄ'Northwind.bak'±¸·ÝÎļþ£º
a¡¢½«Êý¾Ý¿âÖÃÓÚÀëÏß״̬
ALTER DATABASE 'Northwind' SET OFFLINE WITH ROOLBACK IMMEDIATE;
b¡¢»Ö¸´NorthwindÊý¾Ý¿â
RESTORE DATABASE 'Northwind' from DISK = 'C:\Northwind.bak';
c¡¢½«Êý¾Ý¿âÖÃÓÚÔÚÏß״̬
ALTER DATABASE 'Northwind' SET ONLINE WITH ROOLBACK IMMEDIATE;
»Ö¸´Êý¾Ý¿â£º
¹Ø¼ü×Ö£ºAlter Database ±»»Ö¸´µÄÊý¾Ý¿âÃû Set Offline with Rollback immediate;
restore database ±»»Ö¸´µÄÊý¾Ý¿âÃû from disk = '±¸·ÝÎļþ·¾¶';
Alter Database ±»»Ö¸´µÄÊý¾Ý¿âÃû Set OnLine With rollback Immediate;
/////////////////////
string sql = "Alter Database db Set Offline with Rollback immediate;"; //db ÊÇÒª±¸·ÝµÄÊ
Ïà¹ØÎĵµ£º
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈ쵀 Web.configÎļþ£¬°üÀ¨Ä¬ÈϵÄÅäÖÃÉèÖ㬠......
@import url(¡°layout.css¡±)
CSS Selectors: *, p, div span, div > span, *[href], li+li, .title, #container, #title p:first-child, a:link, a:hover, a:visited, p:before, p:after
p:after{content:¡¯url(images/quote.gif)¡¯}
!important State Mode: Off, InProc, StateServer, SQLServer, C ......
Èç¹û²âÊÔµÄurlµØÖ·ÊÇhttp : //www.test.com/testweb/default.aspx, ½á¹ûÈçÏ£º
Request.ApplicationPath: /testweb
Request.CurrentExecutionFilePath: /testweb/default.aspx
Request.FilePath: /testweb/default.aspx
Request.Path: /testweb/default.aspx
Request.PhysicalApplicationPath: E:\WWW\testwebReq ......
ASP.NET»ñÈ¡ÌìÆøÔ¤±¨´óÖ·ÖÎöÓÐ 1µ½Ä³¸öÍøÕ¾ÉÏ·ÖÎöÍøÕ¾µÄ´úÂë»ñÈ¡£»2×Ô¼ºÐ´Çý¶¯·þÎñºÍweb·þÎñ µÚ¶þÖÖˮ̫Éî²»ÔøÉæ¼°¡£
ASP.NETºǫ́³ÌÐò»ñÈ¡ÖÐÑëÆøÏǫ́ÌìÆøÔ¤±¨
1.ÌìÆø·â×°³ÉÒ»¸öʵÌå
2.¿ÉÒÔ»ñÈ¡µ±ÌìÌìÆø£¬Ò²¿ÉÒÔ»ñȡδÀ´ÎåÌìµÄÌìÆø¼¯ºÏ
using System;
using System.Collections.Generic;
using System.Text;
......