C#

<br />
//Removes currently selected node, or root if nothing is selected.<br />
treeview.Nodes.Remove(treeView.SelectedNode);

using Microsoft.SqlServer.Management.Smo;<br />
private static Server srvSql;<br />
private static ServerConnection srvConn;<br />

<br />
 servername = cmbServer.Text;<br />
                     srvConn = new ServerConnection(cmbServer.SelectedItem.ToString());<br />
                                        srvConn.LoginSecure = true;<br />
                   <br />
                    srvSql = new Server(srvConn);<br />

        void Restoring_data()<br />
        {<br />
<br />
            // If there was a SQL connection created<br />
            if (srvSql != null)<br />
            {<br />
                // If the user has chosen the file from which he wants the database to be restored<br />
<br />
                // Create a new database restore operation<br />
                Restore rstDatabase = new Restore();<br />
                // Set the restore type to a database restore<br />
                rstDatabase.Action = RestoreActionType.Database;<br />
                // Set the database that we want to perform the restore on<br />
                rstDatabase.Database = "DataBaseName"<br />
                // Set the backup device from which we want to restore, to a file<br />
                BackupDeviceItem bkpDevice = new BackupDeviceItem(txtbackup.Text.ToString(), DeviceType.File);<br />
                // Add the backup device to the restore type<br />
                rstDatabase.Devices.Add(bkpDevice);<br />
                // If the database already exists, replace it<br />
                rstDatabase.ReplaceDatabase = true;<br />
<br />
                // Perform the restore<br />
                rstDatabase.SqlRestore(srvSql);<br />
<br />
            }<br />
            else<br />
            {<br />
                // There was no connection established; probably the Connect button was not clicked<br />
                MessageBox.Show("A connection to a SQL server was not established.", "Not Connected to Server", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);<br />
            }