以下为引用的内容：
void restorebutton_click(object sender, system.eventargs e)
{
string path = pathtextbox.text;
string dbname = dbdropdownlist.selectedvalue; string restoresql = "use master;";
restoresql += "restore database @dbname from disk = @path;";
string pai = "use master;alter database wy set offline with rollback immediate;alter database wy set online with rollback immediate";
sqlconnection conn = new sqlconnection(connstr);
sqlcommand com1 = new sqlcommand(pai, conn); sqlcommand mycommand = new sqlcommand(restoresql, new sqlconnection(connstr)); mycommand.parameters.add("@dbname", sqldbtype.char);
mycommand.parameters["@dbname"].value = dbname;
mycommand.parameters.add("@path", sqldbtype.char);
mycommand.parameters["@path"].value = path;
try
{
conn.open();
com1.executenonquery();
conn.close();
mycommand.connection.open();
mycommand.executenonquery();
infolabel.text = "恢复成功！<br>已经把备份"+path+"恢复到数据库";
}
catch(exception ex)
{
infolabel.text = "恢复失败！<br>出错信息如下：<br>" + ex.tostring();
}
finally
{
mycommand.connection.close(); }
} | 
