Adding table names in oracle database to combo box in visual studio 2012

Question

0.00/5 (No votes)

See more:

I have tried to display the names of table in oracle database in visual studio 2012 in combo box but i am not sure why it is not displaying

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
con.Open();
OleDbDataAdapter oda = new OleDbDataAdapter("SELECT table_name FROM tabs where table_name Like 'ST%'", con);
DataTable dt = new DataTable();
oda.Fill(dt);
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "table_name";
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex + "");
}
}

What I have tried:

i Have researched and wrote this code but it still does not displays in the combo box.

Posted 13-Feb-16 3:21am

Nareen Nair

Add a Solution

2 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)

KaraUgur · Answer 1 · 2016-02-14T00:57:00

Solution 1

Hello Nareen,

i would suggest that your SQL statement is false.
afaik this is MySQL and won't work with an OracleDB

SELECT table_name FROM tabs where table_name...

For Oracle you need this line of code (PL/SQL)

SELECT table_name, owner, tablespace_name FROM all_tables where table_name like...

the rest looks good :)

Posted 14-Feb-16 0:57am

KaraUgur

Updated 14-Feb-16 0:58am

v2

Comments

Nareen Nair 14-Feb-16 8:41am

hanks sir for the reply. sir i try this also was not working. I have change the location of the code and now it works. I put the code in Form_Load. Then it works.

Nareen Nair 14-Feb-16 9:00am

sir can i ask something what would be the difference between displayMember and valueMember as i am confuse. I want it to appear exactly from the name of the table in my database so which 1 i use as both giving the same answer.

Nareen Nair · Answer 2 · 2016-02-14T02:43:00

C#

private void Form2_Load(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                OleDbDataAdapter oda = new OleDbDataAdapter("SELECT table_name FROM tabs where table_name Not Like 'S%' AND table_name Not Like 'L%'", con);
                DataTable dt = new DataTable();
                oda.Fill(dt);
                comboBox1.DataSource = dt;
                comboBox1.DisplayMember = "table_name";
                
                
                con.Close();



            }

            catch (Exception ex)
            {
                MessageBox.Show(ex + "");
            }
         
        }