Aerolinea.frmcontrolAvion.funconsultarAviones C# (CSharp) Method

        private void funconsultarAviones()
        {
            try {
                using (clasconexion.funobtenerConexion()){
                    string squery = "SELECT ncodavion as CodigoAvion,vaerolinea as Aerolinea,vmodelo as Modelo,vmatricula as Matricula,vdescripciontipoavion as TipoAvion FROM MaAVION "+
                        "inner join TrTIPOAVION on MaAVION.ncodtipoavion=TrTIPOAVION.ncodtipoavion where MaAVION.vdisponibilidad='ACTIVO' order by MaAVION.ncodavion asc ";
                    MySqlCommand cmdc = new MySqlCommand(squery, clasconexion.funobtenerConexion());
                    DataTable dtDatos = new DataTable();
                    MySqlDataAdapter mdaDatos = new MySqlDataAdapter(squery, clasconexion.funobtenerConexion());
                    mdaDatos.Fill(dtDatos);
                    grdaviones.DataSource = dtDatos;
                    grdaviones.AutoResizeColumns();
                    clasconexion.funobtenerConexion().Close();
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }
        }