How to save (.bak) file in specific folder using C#

Question

0.00/5 (No votes)

See more:

In my program I am saving Sql backup file using C#,
In this program when I click on Button "SAVEDIALOG" open,
But I want to save this file in specific folder or specific path.

Means, I dont want to allow user to save this file in anywhere except specific path.

Kindly help me with it.

Below is coding, on which click event I am saving my file.
Noted: It's a desktop application using C#, SQL server 2008.

C#

private void btnCreate_Click(object sender, EventArgs e)
        {
            // If there was a SQL connection created
            if (srvSql != null)
            {
                // If the user has chosen a path where to save the backup file
                if (saveBackupDialog.ShowDialog() == DialogResult.OK)
                {
                    // Create a new backup operation
                    Backup bkpDatabase = new Backup();
                    // Set the backup type to a database backup
                    bkpDatabase.Action = BackupActionType.Database;
                    // Set the database that we want to perform a backup on
                    bkpDatabase.Database = cmbDatabase.SelectedItem.ToString();

                    // Set the backup device to a file
                    BackupDeviceItem bkpDevice = new BackupDeviceItem(saveBackupDialog.FileName, DeviceType.File);
                    // Add the backup device to the backup
                    bkpDatabase.Devices.Add(bkpDevice);
                    // Perform the backup
                    bkpDatabase.SqlBackup(srvSql);
                }
            }
            else
            {
                // There was no connection established; probably the Connect button was not clicked
                MessageBox.Show("A connection to a SQL server was not established.", "Not Connected to Server", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }

Posted 15-Jul-13 20:27pm

Varun_nayak

Updated 15-Jul-13 23:45pm

Johnny J.

v5

Add a Solution

Comments

[no name] 16-Jul-13 2:36am

Is it mandatory to open that savefiledialog...directly u can specify the path

Varun_nayak 16-Jul-13 5:32am

No, its Not mandatory to open savefiledialog,
I just want save my file in specific folder.

well, I got the Solution.. below i mention it

2 solutions

Solution 2

as per above solution.

I solve it my self.

Posted 16-Jul-13 0:30am

Varun_nayak

Comments

Nirav Prabtani 16-Jul-13 6:32am

congrats but do not write like that as a solution please mention it as comment...please remove it from here..>:)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Varun_nayak · Accepted Answer · 2013-07-15T23:39:00

Here The solution:
I add One Textbox in my Form and "txt_FN", in which I am giving My Backup file name,
And Below code saving that file in D drive

C#

private void btnCreate_Click(object sender, EventArgs e)
        {
            // If there was a SQL connection created
            if (srvSql != null)
            {
                // If the user has chosen a path where to save the backup file
               
                string ext = ".bak";
                
  saveBackupDialog.Title = "SAVE a Backupfile";
  saveBackupDialog.FileName = @"D:\\";
                
         
                
                saveBackupDialog.InitialDirectory = @"D:";

                
                    // Create a new backup operation
                   
Backup bkpDatabase = new Backup();
                   
 // Set the backup type to a database backup

  bkpDatabase.Action = BackupActionType.Database;

  // Set the database that we want to perform a backup on
    bkpDatabase.Database = cmbDatabase.SelectedItem.ToString();

                  
  // Set the backup device to a file
                   
 BackupDeviceItem bkpDevice = new BackupDeviceItem(saveBackupDialog.FileName+txt_FN.Text.ToString()+ext, DeviceType.File);
                    
// Add the backup device to the backup
                  
  bkpDatabase.Devices.Add(bkpDevice);
                 
   // Perform the backup
                
    bkpDatabase.SqlBackup(srvSql);
                
    MessageBox.Show("BACKUP SAVED SUCCESSFULLY");
              
 
            }
            else
            {
             
   // There was no connection established; probably the Connect button was not clicked
            
    MessageBox.Show("A connection to a SQL server was not established.", "Not Connected to Server", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }