Aerolinea.frmtipoAvion.funconsultaAvion C# (CSharp) Method

        private void funconsultaAvion()
        {
            try {
                using (clasconexion.funobtenerConexion()) {
                    string scolsultaA = "SELECT ncodtipoavion as CodigoAvion,vdescripciontipoavion as TipoAvion FROM TrTIPOAVION order by ncodtipoavion asc";
                    MySqlCommand cmdCavion = new MySqlCommand(scolsultaA,clasconexion.funobtenerConexion());
                    DataTable dtCavion = new DataTable();
                    MySqlDataAdapter mdCavion = new MySqlDataAdapter(scolsultaA,clasconexion.funobtenerConexion());
                    mdCavion.Fill(dtCavion);
                    grdavion.DataSource = dtCavion;
                    grdavion.AutoResizeColumns();
                    clasconexion.funobtenerConexion().Close();
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }
        }