default.aspx.cs

来自「水晶报表详细资料水晶报表详细资料水晶报表详细资料」· CS 代码 · 共 77 行

using System;
using System.Data;
using System.Configuration;
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;
using System.Data.SqlClient;
using System.IO;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection myConn;
        SqlCommand myCmd;
        string strdbPartPath;
        string strdbName;
        string strdbPath;
        string strlogPath;
        string dbFileExtend;
        string logFileExtend;
        strdbPath = this.TextBox1.Text.Trim();//获取数据库文件名称
        strlogPath = this.TextBox2.Text.Trim();//获取日志文件名称
        if (File.Exists(strdbPath) == true && File.Exists(strlogPath) == true)
        {
            dbFileExtend = strdbPath.Substring(strdbPath.LastIndexOf(".") + 1);//获取文件扩展名
            logFileExtend = strlogPath.Substring(strlogPath.LastIndexOf(".") + 1);//获取日志文件扩展名
            strdbPartPath = strdbPath.Substring(strdbPath.LastIndexOf("\\") + 1);
            strdbName = strdbPath.Substring((strdbPath.LastIndexOf("\\") + 1), (strdbPartPath.LastIndexOf(".")));
            //判断输入文件格式是否正确
            if (dbFileExtend != "mdf" || logFileExtend != "ldf")
            {
                Response.Write("<script>alert('上传文件格式不正确！');location='Default.aspx'</script>");
                return;
            }
            else
            {
                //附加数据库的SQL语句
                string strSql = "EXEC sp_attach_db @dbname='" + strdbName + "',@filename1='" + strdbPath + "',@filename2='" + strlogPath + "'";
                myConn = new SqlConnection("server=a\\mr;database=master;UID=sa;PassWord=''");
                myCmd = new SqlCommand(strSql, myConn);
                myConn.Open();
                try
                {
                    myCmd.ExecuteNonQuery();
                    Response.Write("<script>alert('附加数据库成功！');location='Default.aspx'</script>");
                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message.ToString());
                    Response.Write("<script>alert('附加数据库失败！');location='Default.aspx'</script>");
                }
                finally
                {
                    myConn.Close();
                    myConn.Dispose();
                    myCmd.Dispose();
                }

            }
        }
        else
        {
            Response.Write("<script>alert('请上传附加文件！');location='Default.aspx'</script>");
            return;
        }
    }
    
}