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; } }