Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. SaveFileDialog sfd = new SaveFileDialog();
  2. string stringCon = @"Data Source=(LocalDB)v11.0;AttachDbFilename=|DataDirectory|BakodahDB.mdf;Integrated Security=True";
  3.  
  4. if (sfd.ShowDialog() == DialogResult.OK)
  5. {
  6. using (SqlConnection conn = new SqlConnection(stringCon))
  7. {
  8. string backupStmt = string.Format("backup database [" + System.Windows.Forms.Application.StartupPath + "\BakodahDB.mdf] to disk='{0}' WITH INIT ", sfd.FileName);
  9.  
  10. using (SqlCommand sqlComm = new SqlCommand(backupStmt, conn))
  11. {
  12. conn.Open();
  13. sqlComm.ExecuteNonQuery();
  14. conn.Close();
  15. }
  16. }
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement