Error in Restoring Database

See more:

SQL-server-2000

C#3.0

C#

, +

I have used two buttons one for Backup and other for Restore

private void button1_Click(object sender, EventArgs e)
{
            con = new SqlConnection("Data Source = localhost; Initial Catalog=master ;Integrated Security = True;");
            con.Open();
            if (con.State == ConnectionState.Closed)
                con.Open();
            string qry = "Restore  database Peshawar_Children_Academy_Database from Disk= 'F:\\My.bak'";
            com = new SqlCommand("use master", con);
            com.ExecuteNonQuery();
            com = new SqlCommand(qry, con);
            com.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Has been restored database", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void button2_Click(object sender, EventArgs e)
 {
            con = new SqlConnection("Data Source=localhost;Initial Catalog=Peshawar_Children_Academy_DataBase;Integrated Security = True;");
            con.Open();
            string qry = "backup database Peshawar_Children_Academy_Database to disk ='F:\\My.bak' with init,stats=10";
            com = new SqlCommand(qry, con);
            com.ExecuteNonQuery();
            
            con.Close();
            con.Dispose();
            MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

Problem is when I click 1st Restore button then Restoration of Database has taken successfully but if I click 1st backup button and then click on Restore button then I got the following error Message.
Kindly help me and provide a better soution as soon as possible..Thanks
Message:
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.