Display all procedure names of a database schema into treeview

Below is the project which shows all the existing procedure 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 "DisplayProcedures()" which returns a list collection containing all procedure 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 procedure names of a db 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 DisplayProcedures(String str1)
        {
            DataTable dt = new DataTable();
            try
            {
                con.Open();
            }
            catch (Exception ex)
            {

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

            String proc = "SELECT * FROM INFORMATION_SCHEMA.ROUTINES;";
            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 l3 = c1.DisplayProcedures("");
            TreeNode root1 = new TreeNode("Procedures Names");
            foreach (var l in l3)
            {
                TreeNode s2 = new TreeNode();
                s2.Name = l.ToString();
                root1.Nodes.Add(s2.Name);
            }

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