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