数据还原

//vb      

 strcnn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yaofei;Data Source=(local)"
        strcnn.Execute ("use master ALTER DATABASE YAOFEI SET OFFLINE WITH ROLLBACK IMMEDIATE")
        sql = "restore database YAOFEI from disk='" & Label2.Caption & "'"
        strcnn.Execute (sql)
        strcnn.Execute ("ALTER DATABASE YAOFEI SET ONLINE WITH ROLLBACK IMMEDIATE")
        strcnn.Close

//vc

            string str = "Restore Database wsjc from disk="+"'"+select2.Text.Trim()+"'";
            string str1 = "use master ALTER DATABASE wsjc SET OFFLINE WITH ROLLBACK IMMEDIATE";
            string str2 = "ALTER DATABASE wsjc SET ONLINE WITH ROLLBACK IMMEDIATE";

                mysql.restore(str1);
                mysql.restore(str);
                mysql.restore(str2);

        public int restore(string str)
        {
            int n = 0;
            conn();
            SqlCommand com = new SqlCommand();
            com.CommandType = CommandType.Text;
            com.CommandText = str;
            com.Connection = con;
            n = com.ExecuteNonQuery();
            con.Close();
            return n;
        }