string connStr = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword";
string cmdStr = "select * from information_schema.TABLES where Table_NAME ='tbl_1_1_1_MeasurementData'";
using (MySqlConnection conn = new MySqlConnection(connStr))
{
MySqlCommand cmd = new MySqlCommand(cmdStr, conn);
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int count = reader.GetInt32(0);
if (count == 0)
{
MessageBox.Show("该表不存在!");
}
else if (count == 1)
{
MessageBox.Show("该表存在!");
}
}
}
