private void IdentifierTextBox_TextChanged(object sender, EventArgs e)
{
{
// Search the tables for fixes and return the coordinates,
// then place the coordinates into the list box.
//
if (IdentifierTextBox.TextLength != 0)
{
// First, be sure there is data in the database!
DataTable dtVOR = Form1.VOR;
DataTable dtNDB = Form1.NDB;
DataTable dtFIX = Form1.FIX;
DataTable dtAPT = Form1.APT;
if (dtFIX.Rows.Count != 0)
{
// Load the gridview - can be sorted later. Future: add [Selected]
string filter = "[FacilityID] LIKE '" + IdentifierTextBox.Text + "*" + "'";
DataView dvVOR = new DataView(dtVOR, filter, "FacilityID", DataViewRowState.CurrentRows);
DataView dvNDB = new DataView(dtNDB, filter, "FacilityID", DataViewRowState.CurrentRows);
DataView dvFIX = new DataView(dtFIX, filter, "FacilityID", DataViewRowState.CurrentRows);
DataView dvAPT = new DataView(dtAPT, filter, "FacilityID", DataViewRowState.CurrentRows);
DataTable dtFixList = dvVOR.ToTable(true, "FacilityID", "Latitude", "Longitude");
dtFixList.Merge(dvNDB.ToTable(true, "FacilityID", "Latitude", "Longitude"));
dtFixList.Merge(dvFIX.ToTable(true, "FacilityID", "Latitude", "Longitude"));
dtFixList.Merge(dvAPT.ToTable(true, "FacilityID", "Latitude", "Longitude"));
FixListDataGridView.DataSource = dtFixList;
FixListDataGridView.DefaultCellStyle.Font = new Font("Arial", 9);
FixListDataGridView.Columns[0].HeaderText = "ID";
if (FixListDataGridView.Rows.Count != 0)
{
FixListDataGridView.AutoResizeColumn(0, DataGridViewAutoSizeColumnMode.AllCells);
}
}
else
{
string Msg = "You must select your FAA data folder before you can search for Fixes.";
SCTcommon.SendMessage(Msg);
IdentifierTextBox.Text = string.Empty;
}
}
else
{
FixListDataGridView.DataSource = null;
}
}
}
private void IdentifierTextBox_TextChanged(object sender, EventArgs e)
{
// Search the tables for fixes and return the coordinates,
// then place the coordinates into the list box.
//
if (IdentifierTextBox.TextLength != 0)
{
// First, be sure there is data in the database!
DataTable dtSSD = Form1.SSD;
if (dtSSD.Rows.Count != 0)
{
// Load the gridview - can be sorted later. Future: add [Selected]
string filter = "[SSDcode] LIKE '" + IdentifierTextBox.Text + "*" + "'";
DataView dvSSD = new DataView(dtSSD, filter, "SSDcode", DataViewRowState.CurrentRows);
DataTable dtSSDList = dvSSD.ToTable(true, "SSDcode", "ID");
FixListDataGridView.DataSource = dtSSDList;
FixListDataGridView.DefaultCellStyle.Font = new Font("Arial", 9);
FixListDataGridView.Columns[0].HeaderText = "Code";
FixListDataGridView.Columns[1].Visible = false;
if (FixListDataGridView.Rows.Count != 0)
{
FixListDataGridView.AutoResizeColumn(0, DataGridViewAutoSizeColumnMode.AllCells);
}
}
else
{
string Msg = "You must activate your FAA data before you can search for SIDs & STARs.";
SCTcommon.SendMessage(Msg);
IdentifierTextBox.Text = string.Empty;
}
}
else
{
FixListDataGridView.DataSource = null;
}
}
