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); }
}