private void FillTreeView() { using (SqlConnection connection = new SqlConnection(ConnectionClass.ConnectionStr("master"))) { List <string> nameDB = new List <string>(); try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT name, database_id FROM sys.databases WHERE database_id>4", connection); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { nameDB.Add(reader[0].ToString()); treeView1.Nodes.Add(reader[0].ToString(), reader[0].ToString()); } } foreach (string s in nameDB) { FillNameTable(s); } } catch (SqlException e) { MessageBox.Show("Connection problems, check the correctness of the specified data in the connection window.Or contact your SQL Server administrator.\n Error: " + e.Message); Application.Exit(); } finally { } } }
private static void CheckDB() { using (SqlConnection connection = new SqlConnection(ConnectionClass.ConnectionStr("master"))) { List <string> nameDB = new List <string>(); try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT name, database_id FROM sys.databases WHERE database_id>4", connection); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { nameDB.Add(reader[0].ToString()); } } foreach (string s in nameDB) { if (s == "ShopDB_test_task") { flagDB = true; } } } catch (SqlException e) { Console.WriteLine("Connection problems, check the correctness of the specified data in the connection window.Or contact your SQL Server administrator.\n Error: " + e.Message); } } }
private void FillNameTable(string nameDB) { using (SqlConnection con = new SqlConnection(ConnectionClass.ConnectionStr(nameDB))) { con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM sys.tables", con); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { treeView1.Nodes[nameDB].Nodes.Add(reader[0].ToString(), reader[0].ToString()); } } } }