display names of all tables in sql db in c# in a combo box

Question

1.00/5 (3 votes)

See more:

C#

SQL-Server

VS2010

plz can u help me by giving the c# code for displaying names of the tables i hv created in my sql database...

Posted 10-Mar-13 22:37pm

mayuri koul

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-03-10T22:48:00

All you need to do is issue an SQL query:

SQL

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

So a basic way is:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES", con))
        {
        using (SqlDataReader reader = com.ExecuteReader())
            {
            myComboBox.Items.Clear();
            while (reader.Read())
                {
                myComboBox.Items.Add((string) reader["TABLE_NAME"]);
                }
            }
        }
    }

ravi24june · Answer 2 · 2013-03-10T22:57:00

Solution 2

SQL

SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE'

or

SQL

USE DBName
GO
SELECT * FROM sys.Tables
GO

Use this query to get all the table name from a database

Posted 10-Mar-13 22:57pm

ravi24june

Updated 10-Mar-13 23:02pm

v2

Sarrrva · Answer 3 · 2013-03-10T23:00:00

Hi Try this one,

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
    class Program
    {
//        Try the following

    //For MySQL:

    //SELECT TABLE_NAME 
    //FROM INFORMATION_SCHEMA.TABLES
    //WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='dbName'

    //For MS SQL:

    //SELECT TABLE_NAME 
    //FROM INFORMATION_SCHEMA.TABLES
    //WHERE TABLE_TYPE = 'BASE TABLE' 
        static void Main(string[] args)
        {
            SqlConnection con = new SqlConnection("data source=Your server name;database=database name;uid=sa;pwd=your sql server password");
            con.Open();
            SqlCommand cmd = new SqlCommand("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'", con);
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows == true)
            {
                while (dr.Read())
                {
                    Console.WriteLine("Table Name : " + dr[0]);
                }
            }
            if (!dr.IsClosed)
            {
                dr.Close();
            }
            if (con != null)
            {
                con.Close();
            }
            Console.ReadLine();
        }
    }
}

regards
sarva

Shubh Agrahari · Answer 4 · 2013-03-10T23:01:00

Solution 4

Hi professional

this code will help you

        con.Open();
// type='U' is defining type of table system type or user type
        SqlCommand cmd = new SqlCommand("Use Your_table_name select name from sysobjects where type='U'"), con);
        SqlDataReader dr = cmd.ExecuteReader();
        // lstboxcol.Items.Clear();
        while (dr.Read())
        {

            combobox.Items.Add(dr["Column_Name"].ToString());

        }
        con.Close();

happy to help

Posted 10-Mar-13 23:01pm

Shubh Agrahari

Updated 10-Mar-13 23:07pm

v2

Comments

mayuri koul 11-Mar-13 6:12am

well thank u all for ur answers...:)
i have used the following code..is it correct?..plz help..
private void Form1_Load(object sender, EventArgs e)
{
String strConnection = "Data Source=HP\\SQLEXPRESS;database=MK;Integrated Security=true";

SqlConnection con = new SqlConnection(strConnection);
try
{

con.Open();

SqlCommand sqlCmd = new SqlCommand();

sqlCmd.Connection = con;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "Select table_name from information_schema.tables";

SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

DataTable dtRecord = new DataTable();
sqlDataAdap.Fill(dtRecord);
comboBox1.DataSource = dtRecord;
comboBox1.DisplayMember = "TABLE_NAME";
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

Shubh Agrahari 11-Mar-13 6:14am

what results it giving.?
any exception or error?

mayuri koul 11-Mar-13 6:18am

well..i hv tried it and it is giving the results i.e. showing the names of tables...if psb can you help me in like when i click on any table name from combo box the table contents r shown in data grid view...

Shubh Agrahari 11-Mar-13 6:25am

table content mean column name or all data of columns...?have any procedure..?

mayuri koul · Answer 5 · 2013-03-11T00:23:00

C#

private void Form1_Load(object sender, EventArgs e)
        {
            String strConnection = "Data Source=HP\\SQLEXPRESS;database=MK;Integrated Security=true";

            SqlConnection con = new SqlConnection(strConnection);
            try
            {

                con.Open();

                SqlCommand sqlCmd = new SqlCommand();

                sqlCmd.Connection = con;
                sqlCmd.CommandType = CommandType.Text;
                sqlCmd.CommandText = "Select table_name from information_schema.tables";

                SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

                DataTable dtRecord = new DataTable();
                sqlDataAdap.Fill(dtRecord);
                comboBox1.DataSource = dtRecord;
                comboBox1.DisplayMember = "TABLE_NAME";
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

display names of all tables in sql db in c# in a combo box

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 6

Add your solution here

Preview 0