public void query(string que)
{
DataBackup dbc = new DataBackup();
cmd = new SqlCommand(que, dbc.openconn());
cmd.ExecuteNonQuery();
}
public List <string> GetDatabases()
{
DataBackup dbc = new DataBackup();
List <string> databases = new List <string>();
// select * from sys.databases getting all database name from sql server
cmd = new SqlCommand("select * from sys.databases", dbc.openconn());
dr = cmd.ExecuteReader();
while (dr.Read())
{
databases.Add(dr[0].ToString());
}
dr.Close();
return(databases);
}
public void DoRestore(string servername, string databasename)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
if (string.IsNullOrEmpty(servername) | string.IsNullOrEmpty(databasename))
{
MessageBox.Show("Server Name & Database can not be Blank", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
openFileDialog1.Filter = "Text files (*.bak)|*.bak|All files (*.*)|*.*";
DataBackup dbc = new DataBackup();
Restore(dbc.openconn(), databasename, openFileDialog1.FileName);
MessageBox.Show("Database Backup file has been restored successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public List <string> GetserverNames()
{
try
{
List <string> servers = new List <string>();
DataBackup dbc = new DataBackup();
// select * from sys.servers getting server names that exist
cmd = new SqlCommand("select * from sys.servers", dbc.openconn());
dr = cmd.ExecuteReader();
while (dr.Read())
{
servers.Add(dr[1].ToString());
}
dr.Close();
return(servers);
}
catch (Exception ex)
{
throw ex;
}
}
