Aerolinea.frmcontrolAvion.funbuscaravion C# (CSharp) Method

funbuscaravion() private method

private funbuscaravion ( ) : void
return void
        private void funbuscaravion()
        {
            try {
                string sbuscarA = "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.vaerolinea='"+ txtbuscarAvion.Text +"' order by MaAVION.ncodavion asc ";
                MySqlCommand cmdbuscarA = new MySqlCommand(sbuscarA, clasconexion.funobtenerConexion());
                DataTable dtbuscarA = new DataTable();
                MySqlDataAdapter mdbuscarA = new MySqlDataAdapter(sbuscarA, clasconexion.funobtenerConexion());
                mdbuscarA.Fill(dtbuscarA);
                grdaviones.DataSource = dtbuscarA;
                grdaviones.AutoResizeColumns();
                clasconexion.funobtenerConexion().Close();
                funlimpiar();
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }
        }