初学者急求如何用C#备份数据库文件

[cyc9791]

本人初学C#,我想用C#语言对一个数据库的文档进行存储也就是对数据库的备份.不知道那位大侠能够指导一下!

[lshvs2005]

把 脚本写到程序中: backup database northwind to "DISK=E:\Bak"

再 用 SQL 语句 ，

SqlCommand cmd=new

[cyc9791]

没人回吗?自己顶!!!!!!

[xiaotupansy]

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Data.SqlClient;
using System.Text;


public partial class sqlbackup_backup : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sconn = "uid=sa;pwd=;database=tu;server=";
SqlConnection conn = new SqlConnection(sconn);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
StringBuilder sb = new StringBuilder();
DateTime dt=new DateTime();
dt = DateTime.Now;
sb.Append(Server.MapPath("."));
sb.Append("\\backup\\");
sb.Append(dt.Year.ToString());
sb.Append(dt.Month.ToString());
sb.Append(dt.Day.ToString());
sb.Append(dt.Hour.ToString());
sb.Append(dt.Minute.ToString());
sb.Append(dt.Second.ToString());
sb.Append(".bak");
string s = sb.ToString();
cmd.CommandText = @"backup database tu to disk='" + s + "' ";
try
{
conn.Open();
cmd.ExecuteNonQuery();
Response.Write("Backup successed.");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}

}
}

[kissknife]

上网一搜一大堆，特别是sqlserver的..