public SqlEmploy()

    { }

    public string MyConnStr

    {

        get

        {

                 return System.Configuration.ConfigurationManager.ConnectionStrings["SHDSConnectionString"].ToString();

        }

    }

    public int Back_up(string sql, SqlParameter[] para, CommandType type)

    {

        SqlConnection conn = new SqlConnection(MyConnStr);

        try

        {

            SqlCommand cmd = new SqlCommand(sql, conn);

            if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken)

            {

                conn.Open();

            }

            if (para != null && para.Length > 0)

            {

                foreach (SqlParameter p in para)

                {

                    cmd.Parameters.Add(p);

                }

            }

            cmd.CommandType = type;

            int count = cmd.ExecuteNonQuery();

            return count;

        }

        finally

        {

            conn.Close();

        }

    }

protected void Button1_Click(object sender, EventArgs e)

    {

        string newname = "SHDH" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + ".bak";

        string nepath = Server.MapPath("~/DataBack/") + newname;

        string sql = "BACKUP DATABASE SHDS to DISK ='" + nepath + "'";

        int i = help.Back_up(sql,null,System.Data.CommandType.Text);

        if (i==-1)

        {

            Label1.Text = "已成功备份到服务器路径：" + nepath;

        }

        else

        {

            Label1.Text = "备份数据库出错，该文件可能不存在！";

            Label1.Visible = true;

        }

    }