private void cbDatabase_DropDown(object sender, EventArgs e)
{
if (!SaveData(false))
{
return;
}
Cursor = Cursors.WaitCursor;
cbDatabase.BeginUpdate();
try
{
cbDatabase.Items.Clear();
using (SqlConnection conn = new SqlConnection(Data.GetConnectionString(false)))
{
conn.Open();
// open recordset with databases
using (SqlCommand cmd = new SqlCommand("SELECT name FROM sys.databases ORDER BY name ASC", conn)) // SELECT name FROM master..sysdatabases WHERE name LIKE '%system%' ORDER BY name ASC", conn);
using (SqlDataReader reader = cmd.ExecuteReader()) // WHERE dbid > 6 ~ to exclude system databases
while (reader.Read())
{
cbDatabase.Items.Add(reader.GetString(0));
}
}
}
catch (Exception ex) { GM.ShowErrorMessageBox(this, "Error occured when reading database list!", ex); }
finally
{
cbDatabase.EndUpdate();
Cursor = Cursors.Default;
}
}
public static SqlConnection OpenConnection(bool inclDB = true)
{
SqlConnection conn = new SqlConnection(ConnData.GetConnectionString(inclDB));;
conn.Open();
return(conn);
}
