hi to all,

i was created one database in the mysql. using the following query

create database testdatabase;

when i using the query to retrieve all the databases , it is not return the testdatabase. it return only one database. still more databases r there in the my sql . why, i cannot view the some databases?. the coding i have used is

clsGlobalFields.mycon = new MySqlConnection("server=" + servername + ";port=" + strport + ";uid=" + strusername + ";pwd=" + strpwd);
clsGlobalFields.mycon.Open();
clsGlobalFields.mysqlcmd = new MySqlCommand("show databases", clsGlobalFields.mycon);
clsGlobalFields.mysqlreader = clsGlobalFields.mysqlcmd.ExecuteReader();
while (clsGlobalFields.mysqlreader.Read())
{
cmbdatabase.Items.Add(clsGlobalFields.mysqlreader[0].ToString());
}
clsGlobalFields.mysqlreader.Close();
clsGlobalFields.mycon.Close();

if somebody know, plz help me to get all the databases in the mysql.

plz help me
thank u.

With thanks and regards
MMary