public static SqlConnection GetConn(string dbname) { //SqlConnection con = new SqlConnection(); try { if (con.State == ConnectionState.Open) { con.Close(); } if (con.State == ConnectionState.Closed) { dboperation db = new dboperation(); string connecstring = db.GetServer_Instance(); con.ConnectionString = connecstring; // GetServer_Instance(); con.Open(); Properties.Settings.Default.Connstring = connecstring; Properties.Settings.Default.Save(); // db.TableUpdate(); } return(con); } catch (Exception e) { MessageBox.Show(e.Message); return(con); } }
public static bool DbRestore(System.Windows.Forms.OpenFileDialog backup, String databaseName) { try { dboperation db = new dboperation(); dboperation.GetConn("master"); ServerConnection conn = new ServerConnection(); conn.ServerInstance = ServerInstance(); Server srv = new Server(conn); Restore res = new Restore(); res.Devices.AddDevice(backup.FileName, DeviceType.File); RelocateFile DataFile = new RelocateFile(); string MDF = res.ReadFileList(srv).Rows[0][1].ToString(); DataFile.LogicalFileName = res.ReadFileList(srv).Rows[0][0].ToString(); DataFile.PhysicalFileName = srv.Databases[databaseName].FileGroups[0].Files[0].FileName; RelocateFile LogFile = new RelocateFile(); string LDF = res.ReadFileList(srv).Rows[1][1].ToString(); LogFile.LogicalFileName = res.ReadFileList(srv).Rows[1][0].ToString(); LogFile.PhysicalFileName = srv.Databases[databaseName].LogFiles[0].FileName; res.RelocateFiles.Add(DataFile); res.RelocateFiles.Add(LogFile); res.Database = databaseName; res.NoRecovery = true; res.ReplaceDatabase = true; res.SqlRestore(srv); conn.Disconnect(); return(true); } catch (Exception) { } return(false); }
public static string ServerInstance() { dboperation db = new dboperation(); string serverName = null; string ConnStr = null; RegistryKey rk = null; if (clsproperties.IPAddress != null) { //rk =RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine,clsproperties.IPAddress).OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server"); if (clsproperties.IPAddress != null && clsproperties.CompanyName == null) { return("Data Source=" + clsproperties.IPAddress + ";Initial Catalog=master;User ID=sa;Password=12345;MultipleActiveResultSets=true"); } else if (clsproperties.IPAddress != null && clsproperties.CompanyName != null) { return("Data Source=" + clsproperties.IPAddress + ";Initial Catalog=" + clsproperties.CompanyName + ";User ID=sa;Password=12345;MultipleActiveResultSets=true"); } } else { rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server"); } // RegistryKey rk = localMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server"); String[] instances = (String[])rk.GetValue("InstalledInstances"); int i = 0; if (instances.Length > 0) { while (ConnStr == null) { foreach (String element in instances) { if (i == 0) { if (element == "MSSQLSERVER") { if (clsproperties.CompanyName == null) { ConnStr = "Data Source=" + Environment.MachineName + ";Integrated Security=True;"; if (db.MastDBCheck(ConnStr)) { return(Environment.MachineName); } } else { if (db.CheckDB(Environment.MachineName)) { // ConnStr = "Data Source=" + Environment.MachineName + ";Initial Catalog=" + clsproperties.CompanyName + ";Integrated Security=True"; return(Environment.MachineName); } } } else { serverName = Environment.MachineName + @"\" + element; if (clsproperties.CompanyName == null) { ConnStr = "Data Source=" + serverName + ";Integrated Security=True"; if (db.MastDBCheck(ConnStr)) { return(serverName); } } else { if (db.CheckDB(serverName)) { //ConnStr = "Data Source=" + serverName + ";Initial Catalog=" + clsproperties.CompanyName + ";Integrated Security=True"; return(serverName); } } } } else { } } i++; } } return(serverName); }
public clssalesinvoice() { dboperation db = new dboperation(); }