Treeview control showing all table names in a database schema

Below is the project which shows all the existing table names in any particular database schema into a tree-view control. We have used a class library "stored_proc_db_disp_dll" and imported it's reference into a windows project. The class library contains a function "DisplayTables()" which returns a list collection containing all table names of a database schema and windows project binds that list to tree-view control.

Below is the design view of the project:

Tree-view displaying all table names of a schema

Here is code for class library:


namespace stored_proc_db_disp_dll
{
    public class Class1
    {
        MySqlConnection con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=test");
        MySqlCommand cmd=null;

        MySqlDataReader dr;

public List DisplayTables()
        {
            DataTable dt = new DataTable();
            try
            {
                con.Open();
            }
            catch (Exception ex)
            {

                Console.WriteLine("db connection error" + ex);
            }

            String proc = "SELECT TABLE_NAME from information_schema.tables where table_type='base TABLE' and TABLE_SCHEMA='test';";
            cmd = new MySqlCommand();
            cmd.CommandText = proc;
            cmd.Connection = con;
            MySqlDataReader dr = cmd.ExecuteReader();
            List l1 = new List();
            while (dr.Read())
            {
                l1.Add(dr.GetString(0));
            }
            if (con.State == ConnectionState.Open)
                con.Close();



            return l1;
        }

       
        public Class1()
        {
            cmd = new MySqlCommand();
            cmd.Connection = con;
            try
            {
                con.Open();
            }
            catch (MySqlException ex)
            {
                Console.WriteLine("db connection error"+ ex);
            }

        }
   
    }


Here is the code for windows project:

using stored_proc_db_disp_dll;

namespace create_procedure_demo
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
            treeView1.Nodes.Clear();
           
            Class1 c1 = new Class1();
            List l2 = c1.DisplayTables();
            TreeNode root = new TreeNode("Table Names");
            foreach(var l in l2)
            {
                TreeNode s1 = new TreeNode();
                s1.Name = l.ToString();
                root.Nodes.Add(s1.Name);
            }

            treeView1.Nodes.Add(root);
        }
}
}