My code is shown below, I can select * from employees but I cannot get any data back from SHOW FIELDS, I do not receive an error, in fact, something is returned but I'm not sure what. I can execute the command:
SHOW FIELDS FROM test.employees
in the Control Center just fine, even cmd.ExecuteReader will enter reader.Read() once, something is returned but what does it look like?
This is .NET code
============================
OleDbConnection cn = new OleDbConnection(@"Provider=MySQLProv;Data Source=test;DB=test;UID=;PWD=;PORT=3306");
cn.Open();
OleDbCommand cmd = new OleDbCommand("SHOW FIELDS FROM test.employees",
cn);
cmd.CommandType = CommandType.Text;
DataTable metaData = new DataTable();
OleDbDataAdapter ad = new OleDbDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(metaData);===========================
_________________________________________________________________
Help protect your PC. Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
