ASP.netÒ³ÃæÊµÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬Êǿⴴ½¨£¡
/// <summary>
/// ´´½¨Êý¾Ý¿â¡£
/// </summary>
/// <param name="srvName">±íʾҪÁ¬½ÓµÄ·þÎñÆ÷Ãû</param>
/// <param name="dbName">Ö¸¶¨Òª´´½¨µÄÊý¾Ý¿âÃû</param>
private string CreateDB(string srvName, string dbName)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass();
srv.Connect(srvName, "sa", "");
// н¨Êý¾Ý¿âÃû(°üÀ¨Â·¾¶)
string dbPath = srv.Registry.SQLDataRoot + "\\DATA\\" + dbName;
bool DBExist = false;
foreach (SQLDMO.Database db in srv.Databases)
{
if (db.Name == dbName)
{
DBExist = true;
}
}
&nbs
Ïà¹ØÎĵµ£º
public class DBHelper
{
private static SqlConnection connection;
public static SqlConnection Connection
{
&nb ......
1¡¢Ìí¼ÓWeb.config£¬ < system.web>< /system.web>ÖÐÌí¼Ó< customErrors mode="On"
defaultRedirect="ApplicationErroy.aspx" >< /customErrors>½Úµã£¬
2¡¢Ìí¼ÓGlobal.asaxÎļþ£¬ÕÒµ½Application_Errorʼþ£¬¼ÓÈëÒÔÏ´úÂ룺
//ÕâÊÇÌí¼ÓÁËÒ»¸öÈ«¾ÖÓ¦ÓÃ³Ì ......
Global.asax Îļþ£¬ÓÐʱºò½Ð×ö asp.net Ó¦ÓóÌÐòÎļþ£¬ÌṩÁËÒ»ÖÖÔÚÒ»¸öÖÐÐÄλÖÃÏìÓ¦Ó¦ÓóÌÐò¼¶»òÄ£¿é¼¶Ê¼þµÄ·½·¨¡£Äã¿ÉÒÔʹÓÃÕâ¸öÎļþʵÏÖÓ¦ÓóÌÐò°²È«ÐÔÒÔ¼°ÆäËüһЩÈÎÎñ¡£ÏÂÃæÈÃÎÒÃÇÏêϸ¿´Ò»ÏÂÈçºÎÔÚÓ¦ÓóÌÐò¿ª·¢¹¤×÷ÖÐʹÓÃÕâ¸öÎļþ¡£
¸ÅÊö
Global.asax λÓÚÓ¦ÓóÌÐò¸ùĿ¼Ï¡£ËäÈ» Visual Studio .NET »á×Ô¶¯²åÈëÕ⸠......
Ö÷Ìå¼Ü¹¹
¡¡¡¡¸÷ƵµÀ·Ö±ðλÓÚ²»Í¬µÄWeb Project(¾ßÓжÀÁ¢µÄ¶þ¼¶ÓòÃû)£¬²¢½«ËùÓеÄÒµÎñÂß¼ÒÔ¼°Êý¾Ý·ÃÎʹ¦ÄÜ·â×°³ÉClass Library£¬ËùÓÐÆµµÀ¹²ÓÃÕâ¸öClass Library¡£
¡¡¡¡ÏÂÃæÏêϸ½éÉÜʵÏÖ·½·¨¡£
¡¡¡¡¼ÙÉèÍøÕ¾ÓÐÈý¸öƵµÀ£¬ÐÂÎÅ¡¢ÂÛ̳ÒÔ¼°²©¿Í£¬¶ÔÓ¦µÄ¶þ¼¶ÓòÃûΪ"news"¡¢"forum"¡¢"blog"¡£³ý´ËÖ®Í⣬»¹ÐèÒªÁ ......
Ò»¡¢ÔÀí£º
ҪʵÏÖ½ø¶ÈÌõµÄʵʱ·´Ó³£¬ºËÐĵļ¼Êõ¾ÍÊǶÔÉÏ´«µÄÊý¾Ý½øÐГ·Ö¿é”¶ÁÈ¡£¬ÔÚ¶Áȡÿ¿éÊý¾Ýʱ¼Ç¼µ±Ç°ÒÑÉÏ´«µÄ¿éÊý£¬¸ù¾Ý
·Ö¿éµÄ´óС£¬¼´¿ÉÖªµÀÒÑÉÏ´«µÄ´óС£¬¸ù¾Ý×Ü´óС£¬¼´¿ÉÖªµÀµ±Ç°ÉÏ´«µÄ½ø¶È¡£¾ßÌåµÄ¼¼Êõ»¹ÊÇÀûÓÃÒþº¬µÄHttpWorkerRequest
£¬ÓÃËüµÄGetPreloadedEn ......