CommandText = "select id from table";

            MySqlConnection myConnection = new MySqlConnection(myConnectionString);
            MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);
            try
            {
                myConnection.Open();

                MySqlDataReader rdr = myCommand.ExecuteReader();
              
              ...........................................      
                }