Do Not Restore the Back Up File.......

See more:

C#

DirectoryInfo dir;
string con = "";
SqlConnection _SqlConnection = null;
SqlCommand _SqlCommand = null;
string BackupPath_bak = Application.StartupPath + "\\Backup\\mybck_mbk_001";
string BackupPath = Application.StartupPath + "\\Backup\\mybck_mbk_002";
public BackUp()
{
InitializeComponent();
}
protected override bool ProcessCmdKey(ref System.Windows.Forms.Message msg, System.Windows.Forms.Keys keyData)
{
if (msg.WParam.ToInt32() == (int)Keys.Enter)
{
SendKeys.Send("{Tab}");
return true;
}
if (msg.WParam.ToInt32() == (int)Keys.Escape)
{
this.Close();
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}

private void btnBrowse_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();

            openFileDialog1.InitialDirectory = Application.StartupPath.ToString();
            openFileDialog1.Filter = "bak files (*.bak; *.mbk)|*.bak; *.mbk";
            openFileDialog1.FilterIndex = 2;
            openFileDialog1.RestoreDirectory = true;
            openFileDialog1.FileName = Application.StartupPath + "\\Backup\\" + "PragatiDB" + "-" + DateTime.Now.Day + DateTime.Now.Month + DateTime.Now.Year;
            openFileDialog1.RestoreDirectory = true;

            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                txtFileName.Text = openFileDialog1.FileName.ToString();
            }
        }