How do ihow do I create password protected zip file of .bak file after taking backup programmatically? ...

See more:

C#

SQL

database

backup

I am taking backup of database on button click event. But for security purpose I want to create password protected zip file.Which will have that .bak file which recently created. And after creating zip delete that .bak file. I tried this code but it's constantly throwing exception that "unsuported file format"

What I have tried:

private void btnSave_Click(object sender, EventArgs e)
{
    if (txtLocation.Text == string.Empty)
    {
        MessageBox.Show("Please select Backup File Location", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
    else
    {
        try
        {
            string FileName = "'"+txtLocation.Text + "Backup";
            string BackupFileName = "" + FileName + ".bak'";
            string BackupZipFileName = "" + FileName + ".zip'";
            cn.Open();
            cmd.CommandText = @"BACKUP DATABASE POS TO DISK = " + BackupFileName;
            cmd.CommandType = CommandType.Text;
            cmd.Connection = cn;
            dr = cmd.ExecuteReader();
            dr.Close();
            cn.Close();
           // byte[] bt = File.ReadAllBytes(BackupFileName);
            FileStream fStream = File.Create(BackupZipFileName);
            GZipStream gZip = new GZipStream(fStream, CompressionMode.Compress);
            //zip process
            //delete backupfilename
            //string sZipFileName = BackupFileName.Replace(".bak", ".zip");
            //byte[] bt = File.ReadAllBytes(sZipFileName);
            //FileStream fStream = File.Create(sZipFileName, bt.Length, FileOptions.Encrypted);

            //    GZipStream gZip = new GZipStream(fStream, CompressionMode.Compress);

            //    gZip.Write(bt, 0, bt.Length);
            //    gZip.Close();
            //    gZip.Dispose();

            MessageBox.Show("Backup Successfull", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
            this.Close();
        }
        catch (Exception ex)
        {
            cn.Close();
            MessageBox.Show(ex.Message);
        }
    }