Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. com.CommandText = "ALTER DATABASE [" + Application.StartupPath + "\DB\mydb.mdf" + "] SET Single_User WITH Rollback Immediate;"
  2. + "ALTER DATABASE [" + Application.StartupPath + "\DB\mydb.mdf" + "] SET Multi_User;" + "USE [master]; RESTORE DATABASE [mydb] FROM DISK = N'" + filename + "' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10";
  3.  
  4. con2.ConnectionString = @"Data Source=.SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + @"DBmydb.mdf;Integrated Security=True;MultipleActiveResultSets=True;Connect Timeout=30;User Instance=true;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement