public string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\namedatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

        public SqlConnection connection = new SqlConnection();    

        public BackUp()

        {

            InitializeComponent();

کد زیر را برای اتصال به دیتابیس باید بنویسید.

            connection.ConnectionString = connectionString;

        }

        public void restoure(string filename)

        {

            string databaselocation = System.Windows.Forms.Application.StartupPath + "\\namedatabase.mdf";

            string query = "Alter Database [" + databaselocation +

                "] set Single_User with ROLLBACK IMMEDIATE USE master Restore Database [" + databaselocation +

                "] From Disk='" + filename + "'";

            SqlCommand command = new SqlCommand(query, connection);

            command.Connection.Open();

            command.ExecuteNonQuery();

            command.Connection.Close();

        }

روی باتون کلیک کرده و کد زیر را بنویسید

        private void Btnrestore_Click(object sender, EventArgs e)

        {

            try

            {

                OpenFileDialog opendialog = new OpenFileDialog();

                opendialog.Filter = "SQL Server Backup (*.Bak)|*.Bak";

                if (opendialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)

                {

                    lbfilename.Text = Path.GetFileName(opendialog.FileName);

                    lbaddress.Text = Path.GetDirectoryName(opendialog.FileName);

                    pictureEdit3.Show();

                    string filename = opendialog.FileName;

                    restoure(filename);

                    MessageBox.Show("بازگردانی اطلاعات باموفقیت انجام شد");

                }

            }

            catch (Exception)

            {

                FMessegeBox.FarsiMessegeBox.Show("خطای بازگردانی");

            }