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