asp.net(C#)ʵÏÖSQL2000Êý¾Ý¿â±¸·ÝºÍ»¹Ô
asp.net(C#)ʵÏÖSQL2000Êý¾Ý¿â±¸·ÝºÍ»¹Ô
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class databasemanager : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
/// <summary>
/// Êý¾Ý¿â»Ö¸´ºÍ±¸·Ý
/// </summary>
#region SQLÊý¾Ý¿â±¸·Ý
/// <summary>
/// SQLÊý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="ServerIP">SQL·þÎñÆ÷IP»ò(Localhost)</param>
/// <param name="LoginName">Êý¾Ý¿âµÇ¼Ãû</param>
/// <param name="LoginPass">Êý¾Ý¿âµÇ¼ÃÜÂë</param>
/// <param name="DBName">Êý¾Ý¿âÃû</param>
/// <param name="BackPath">±¸·Ýµ½µÄ·¾¶</param>
public static void SQLBACK(string ServerIP, string LoginName, string LoginPass, string DBName, string BackPath)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
Ïà¹ØÎĵµ£º
À´Ô´£ºhttp://www.pccode.net/info/2010/01/25/20100125-1220.html
ʵ¼ÊÉÏEval·½·¨ÊÇTemplateControlµÄ£¬¶øSystem.Web.UI.PageºÍSystem.Web.UI.UserControl¶¼¼Ì³ÐÓÚTemplateControl£¬ËùÒÔÎÒÃÇ¿ÉÒÔÔÚPageºÍUserControlÉÏÖ±½Óµ÷Óøö·½·¨¡£
Page.Eval·½·¨¿ÉÒÔ°ï ......
ÏÖÔÚµÄÆóÒµ¼¶¿ª·¢ÏîÄ¿£¬ÌرðÊÇÍøÕ¾Ò»°ã¶¼»áÓõ½log¹¦ÄÜ£¬ÏëÏë´ó²¿·Ö»áÓÃEnterprise Logging Application Block µÄ¹¦ÄÜ »òÕß×Ô¼ºÐ´Ò»¸ö×é¼þ£¬¼Ç¼ϵͳÈÕ־ʼþ£¬¸üºÃµÄ¸ú×ÙÁ˽âϵͳÔËÐÐÇé¿ö, ÏÖÓÃASP.NET MVC µÄ¹ýÂËÊôÐÔʵÏÖlog¹¦ÄÜ£¡
ASP.NET MVCµÄfilter ÊÇÒ»¸öÊôÐÔ£¬¿ÉÒÔÓ¦Ó ......
´íÎóÐÅÏ¢£º
»Ø·¢»ò»Øµ÷²ÎÊýÎÞЧ¡£ÔÚÅäÖÃÖÐʹÓà <pages enableEventValidation="true"/> »òÔÚÒ³ÃæÖÐʹÓà <%@ Page EnableEventValidation="true" %> ÆôÓÃÁËʼþÑéÖ¤¡£³öÓÚ°²È«Ä¿µÄ£¬´Ë¹¦ÄÜÑéÖ¤»Ø·¢»ò»Øµ÷ʼþµÄ²ÎÊýÊÇ·ñÀ´Ô´ÓÚ×î³õ³ÊÏÖÕâЩʼþµÄ·þÎñÆ÷¿Ø¼þ¡£Èç¹ûÊý¾ÝÓÐЧ²¢ÇÒÊÇÔ¤Æڵģ¬ÔòʹÓà ClientScriptMan ......
ÎÊÌâÌá³ö
¡¡¡¡ÎÒʹÓùý¼¸´ÎSQL Server£¬µ«ËùÓÐÓëÊý¾Ý¿âµÄ½»»¥¶¼ÊÇͨ¹ýÓ¦ÓóÌÐòµÄ±àÂëÀ´ÊµÏֵġ£ÎÒ²»Öªµ½ÔÚÄÄÀïʹÓô洢¹ý³Ì£¬Ò²²»Á˽âʵÏÖ´æ´¢¹ý³ÌÐèÒª×öÄÄЩ¹¤×÷¡£Ï£ÍûÄÜÏêϸ˵Ã÷¡£
¡¡¡¡×¨¼Ò´ðÒÉ
¡¡¡¡´æ´¢¹ý³ÌÊÇ´æ´¢ÓÚÊý¾Ý¿âÖеÄÒ»×éT-SQLÓï¾ä¡£ÓÐÁË´æ´¢¹ý³ÌÖ®ºó£¬ÓëÊý¾Ý¿âµÄ½»»¥¾ÍûÓбØÒªÔÚ³ÌÐòÖÐдһ¶ÑµÄSQLÓï¾ä£¬¶ ......
ÕÒµ½Ò»±é½²½âÈý²ã½á¹¹±È½ÏÇå³þÒ׶®µÄÎÄÕ£¬ÒýÓÃһϣ¬ÁôΪѧϰ¡£
Èý²ãʽ¿ª·¢ÖеIJã´Î»®·ÖÌÖÂÛ
ÏȾÙÒ»¸öÔø¾ÔÚÄı¾ÊéÉÏ¿´µ½µÄÀý×Ó£ºÏÖÔÚÄãÏëÔÚ1Ã׿íµÄСϪÉϽ¨Ò»×ùÇÅ£¬Äã»áÔÚÉÏÃæ·Å¿éľ°å¾ÍÍêÁË¡£Èç¹ûÏëÔÚ¿íÒ»µãµÄСºÓÉϽ¨ÕâÇÅ£¬Äã¾ÍÐèÒª¼ÆËãľ²ÄÓÃÁÏ£¬¼Û¸ñµÈ£¬Èç¹ûÐèÒª±ðÈË°ï棬Ä㻹Ҫ¶àһЩͼֽʲôµÄÈñðÈËÀí½âÄãµÄÏë ......