How I list table name in mysql into combobox C#?

Question

0.00/5 (No votes)

See more:

Hello,
I have a database in mysql name "data". In data I have 3 table which name "a_table", "b_table","c_table".
How I list the name of table in database "data"?
Please help. Thanks.

Posted 30-Jul-15 19:23pm

Member 10390715

Add a Solution

Comments

Arasappan 31-Jul-15 1:36am

Please quit bit clear what do u want.

Member 10390715 31-Jul-15 2:16am

Yes. I want to list table name in mysql database

1 solution

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)

Michael_Davies · Answer 1 · 2015-07-30T20:43:00

Solution 2

CSS

SHOW TABLES IN data;

Try the MySQL Manual, it is full of useful information.

https://dev.mysql.com/doc/refman/5.0/en/show-tables.html

Posted 30-Jul-15 20:43pm

Michael_Davies

Comments

Member 10390715 31-Jul-15 2:48am

Hello, I use this query:
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%nh%'
And mysql return me the result I want.
Now I make a fuction in C# like this to get table name return into combobox. But it not work.
What wrong with it?
<pre lang="c#">
string myConnection = "Server=localhost;Database=data;Port=3306;User ID=root;Password=;Charset=utf8";
string query = "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%nh%'";
conDatabase = new MySqlConnection(myConnection);
MySqlCommand cmdDataBase = new MySqlCommand(query, conDatabase);
MySqlDataReader myReader;
try
{
conDatabase.Open();
myReader = cmdDataBase.ExecuteReader();
cb_data_name.Items.Clear();
if (myReader.HasRows == true)
{
while (myReader.Read())
{
cb_chon.Items.Add((string)myReader[0]);
}
}
}
catch
{

}
</pre>

Michael_Davies 31-Jul-15 3:05am

Here's the thing; You did not ask this question in your original statement, how can anyone provide you with help that is relevant if you do not ask the full question, you do know how to get table names that is not the problem.

Have you walked through with the debugger and if so does it enter the read loop at least once. You might notice that none of your tables are LIKE %nh% as you say their names are a_table, b_table and c_table, unless I spelt those names incorrectly and missed the nh out!

Beware: you are selecting from the INFORMATION_SCHEMA so your SELECT will pull ALL tables matching the LIKE not just for the database data.

Member 10390715 31-Jul-15 4:50am

yes. I just want list table name in one database. How can I fix it?

Michael_Davies 31-Jul-15 4:53am

And the solution I provided already?