还原数据库

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
using SQLDMO;

namespace 还原数据库
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source=.;Initial Catalog=master;User ID=sa;pwd =";
            conn.Open();

            string sql = "SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='Huihai'";

            SqlCommand cmd1 = new SqlCommand(sql, conn);
            SqlDataReader dr;

            ArrayList list = new ArrayList();

            try
            {
                dr = cmd1.ExecuteReader();
                while (dr.Read())
                {
                    list.Add(dr.GetInt16(0));
                }
                dr.Close();

            }
            catch (SqlException eee)
            {
                MessageBox.Show(eee.ToString());
                return;
            }
            finally
            {
                conn.Close();
            }

            conn.Open();
            for (int i = 0; i < list.Count; i++)
            {
                cmd1 = new SqlCommand(string.Format("KILL {0}", list[i].ToString()), conn);
                cmd1.ExecuteNonQuery();
                MessageBox.Show("you have killed thread " + list[i].ToString());
            }

            try
            {
                SQLDMO.Restore restore = new SQLDMO.RestoreClass();
                SQLDMO.SQLServer sqlserver = new SQLDMO.SQLServerClass();
                sqlserver.LoginSecure = false;
                sqlserver.Connect("localhost", "sa", ""); restore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
                restore.Database = "Huihai";
                restore.Files = @"D:/a.bak";
                //restore.BackupSetName = "Huihai";
                restore.FileNumber = 1;
                restore.SQLRestore(sqlserver);

                MessageBox.Show("OK");
            }
            catch (SqlException ee)
            {
                MessageBox.Show(ee.ToString());

            }
        }

    }
}