using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data;
using System.Data.SqlClient;


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

    }

     protected void btnAdjuntar_Click(object sender, EventArgs e) {

        try {
            using (SqlConnection connection = new SqlConnection("Server=RAPTOR\\SQL08;Database=PUBS;Uid=sa;Pwd=as")) {
                connection.Open();
                SqlCommand cmd = new SqlCommand("AttachDatabase", connection);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@database", SqlDbType.VarChar);
                cmd.Parameters["@database"].Value = "NORTHWND";
                cmd.Parameters.Add("@ruta", SqlDbType.VarChar);
                cmd.Parameters["@ruta"].Value = "E:\\SQL Server\\SQL08\\";

                cmd.ExecuteNonQuery();

                cmd.Dispose();

                Label1.Text = "Adjuntada base de datos";
            }
        }
        catch (Exception Ex) {
            Label1.Text = Ex.Message;
        }        

    }
    protected void btnSeparar_Click(object sender, EventArgs e) {

         try {
             using (SqlConnection connection = new SqlConnection("Server=RAPTOR\\SQL08;Database=PUBS;Uid=sa;Pwd=as")) {
                 connection.Open();
                 SqlCommand cmd = new SqlCommand("DetachDatabase", connection);
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add("@database", SqlDbType.VarChar);
                 cmd.Parameters["@database"].Value = "Northwind";

                 cmd.ExecuteNonQuery();

                 cmd.Dispose();

                 Label1.Text = "Separada base de datos";
             }
         }
         catch (Exception Ex) {
             Label1.Text = Ex.Message;
         }

    }
}