private void create_db_btn_Click(object sender, EventArgs e) { if (textbox_servername.Text == "" /* || * textbox_dbfilename.Text == "" */|| textbox_dbname.Text == "" /* || * textbox_userid.Text == "" || * textbox_userpwd.Text == ""*/) { MessageBox.Show("Fill in all the required fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DBParams dbParams = new DBParams(textbox_servername.Text, textbox_dbname.Text, textbox_dbname.Text, textbox_dbfilename.Text, "", "", textbox_userid.Text, textbox_userpwd.Text); Database newDB = new Database(dbParams); newDB.CreateDatabase(Global.masterParams); Global.databases.Add(newDB); }
public static void PopulateDatabaseList() { if (Databases == null) { Databases = new List <Database>(); } if (databaseNames == null) { databaseNames = new List <string>(); } SqlConnection masterConnection = new SqlConnection { ConnectionString = Database.BuildConnectionString(masterParams) }; string sqlGetAllDatabasesQuery = "SELECT name FROM master.sys.databases"; using (SqlCommand com = new SqlCommand(sqlGetAllDatabasesQuery, masterConnection)) { masterConnection.Open(); using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { string name = reader.GetString(0); if (name == "msdb" || name == "model" || name == "master" || name == "tempdb") { continue; } DBParams dp = new DBParams(masterParams.ServerName, name, "", "", "", "", GlobalContext.masterParams.UserId, GlobalContext.masterParams.Password); Database d = new Database(dp); d.PopulateTableList(); GlobalContext.Databases.Add(d); } } masterConnection.Close(); } return; }