This is a easy way to explore the items from database.
In this Program 3 Modules having:
module 1:
Select all database name and load into combo box.
module 2:
Select all Table name from particular database and load into list box.
module 3:
Select all the column name from particular table and load into list box.
Note: Here particular database or table means dynamic selection at run time.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
namespace db_explore { public partial class Form1 : Form { public Form1() { InitializeComponent(); } //Variable declaration SqlConnection con; SqlCommand cmd; SqlDataReader dr = null; String st; //For database private void Form1_Load(object sender, EventArgs e) { //DB Connection string con = new SqlConnection(); con.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"; con.Open(); MessageBox.Show("Successfully Connected."); //message notification for database connection //select database and load into combo box st = "select name from sys.databases"; //database selection query cmd = new SqlCommand(st, con); dr = cmd.ExecuteReader(); while (dr.Read()) { cbox.Items.Add(dr[0].ToString()); //add the database names into combo box } dr.Close(); } //For Table name private void cbox_SelectedIndexChanged(object sender, EventArgs e) { lbox1.Items.Clear(); // clearing listbox1 lbox2.Items.Clear(); // clearing listbox2 String ts; ts = "SELECT * FROM " + cbox.SelectedItem + ".sys.Tables"; //table selection query for particular DB cmd = new SqlCommand(ts,con); dr = cmd.ExecuteReader(); //execute data reader while (dr.Read()) { lbox1.Items.Add(dr[0].ToString()); //add the table names into listbox2 for particular DB } dr.Close(); } //For column name private void lbox1_SelectedIndexChanged(object sender, EventArgs e) { lbox2.Items.Clear(); //clearing listbox2 String cs; //list the column from particular database & table cs = "SELECT column_name 'Column Name' FROM " + cbox.SelectedItem + ".INFORMATION_SCHEMA.columns WHERE table_name ='"+ lbox1.SelectedItem +"' "; // MessageBox.Show(cs); //message for verification of query cmd = new SqlCommand(cs, con); dr = cmd.ExecuteReader(); //execute data reader while (dr.Read()) { lbox2.Items.Add(dr[0].ToString()); //add the column names into listbox2 for particular table } dr.Close(); } private void btn_can_Click(object sender, EventArgs e) { this.Close(); //close the application } } |
It is a dynamic. We can select the database dynamically to explore the content for tables available in database and we can select the table name to explore the column names for particular table.
