Skip to main content

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



Comments

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...

Add worklog in Jira using Python

 Below is the Python code to add the worklog in Jira. You need to install a request library for this. Here is the code: import requests from requests.auth import HTTPBasicAuth import json url = "https://your jira address here/rest/api/2/issue/ticket_number/worklog" auth = HTTPBasicAuth("username", "jira access token") headers = {     "Accept": "application/json",     "Content-Type": "application/json" } payload = json.dumps({     "comment": {         "content": [             {                 "content": [                     {                         "text": "This is for QA Testing",                         "type": "text"                     } ...

Some GUI examples in Python using customtkinter

 Some GUI examples in Python using customtkinter import customtkinter import os from PIL import Image class ScrollableCheckBoxFrame(customtkinter.CTkScrollableFrame):     def __init__(self, master, item_list, command=None, **kwargs):         super().__init__(master, **kwargs)         self.command = command         self.checkbox_list = []         for i, item in enumerate(item_list):             self.add_item(item)     def add_item(self, item):         checkbox = customtkinter.CTkCheckBox(self, text=item)         if self.command is not None:             checkbox.configure(command=self.command)         checkbox.grid(row=len(self.checkbox_list), column=0, pady=(0, 10))         self.checkbox_list.append(checkbox)     def remove_item(self, it...