How to check whether database or table exist?

Question

Hello,,
I want to to check whether the Database is already exist in to the Specified Database server.. and also for table.. Is anybody knows the query for this?? i alreasy use the following query . but as the ExecuteNonQuery() only return the rows affeted by the Insert, Update and Delete query. Plz Help
query = "show tables from db_micro_structure;
com = new MySqlCommand(query, myConnection);
try
{
myConnection.Open();
MessageBox.Show(com.ExecuteNonQuery().ToString());
myConnection.Close();
}
catch
{
}

try abc · Answer

Thnaks Jan Montano,
I am really thank ful for help me second time in query problem..

Jan Montano · Answer

In checking the table name, you could use:
select * from information_schema.tables where table_name = tablename
In checking if your database exists... You have to catch it in your exception. Try to play around connecting with an existing database and a non-existing one. Then you'll get the exception it will throw if the database is non-existing.
I don't know if there's a better way to do database checking.