Restore database through c# codings

Question

Hai,

   I want to restore database backup file(.bak) to sql server 2012 from my c# program. Restored database name is  from textbox text.

I used the following coding. It works on local connection only. when i used the same coding on my sql server connected with name like XXXX\SQL EXPRESS i got error restored failed for server 'XXXX\SQL EXPRESS'.

Please help me.... Thanks in advance....

 

ServerConnection srvConn = new ServerConnection(@"XXXXX\\SQLEXPRESS");

 

 instead of this line i use

 

ServerConnection srvConn = new ServerConnection("localhost"); 

this line work on loacl connection. 

 

 

 try

{ 

private static Server srvr;

ServerConnection srvConn = new ServerConnection(@"WIN-6A67QTTNU6J\\SQLEXPRESS");

srvConn.LoginSecure = true;

srvr = new Server(srvConn);

 

 

Restore rstDatabase = new Restore();

rstDatabase.Action = RestoreActionType.Database;

string name = txt_cmpnyname.Text;

rstDatabase.Database = name;

BackupDeviceItem bkpDevice = new BackupDeviceItem("E:\\shop", DeviceType.File);

rstDatabase.Devices.Add(bkpDevice);

rstDatabase.ReplaceDatabase = true;

rstDatabase.SqlRestore(server);

MessageBox.Show("Restored Successfully");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}