private void frmSerchAirLinesFare_Load(object sender, EventArgs e)
{
List <AirLinesFare> listAirLinesFare = AirLinesFareBL.GetAirLinesFare();
bindingSource1.DataSource = listAirLinesFare;
foreach (AirLinesFare airelineItem in listAirLinesFare)
{
ListItem litem = new ListItem();
litem.Text = string.Format("Algo {0} - {1}", airelineItem.CatAirLinFarName, airelineItem.CatAirLinFarId);
litem.Value = airelineItem.CatAirLinFarId;
comboBox1.Items.Add(litem);
}
}
/// <summary>
/// Se definen las columnas, los nombres y el orden automatico
/// Se les asigna el Texto de cabecera, se extrae la lista con los datos
/// de la BD y se hace el llenado del DataGridView
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ucConsultingAirLinesFare_Load(object sender, EventArgs e)
{
dataGridView1.MultiSelect = false;
dataGridView1.ColumnCount = 7;
// Set the properties of the DataGridView columns.
dataGridView1.Columns[0].Name = "CatAirLinFarId";
dataGridView1.Columns[1].Name = "CatAirLinFarName";
dataGridView1.Columns[2].Name = "CCAut";
dataGridView1.Columns[3].Name = "CCMan";
dataGridView1.Columns[4].Name = "Cash";
dataGridView1.Columns[5].Name = "PMix";
dataGridView1.Columns[6].Name = "Misc";
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[3].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[4].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[5].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.Columns[6].SortMode = DataGridViewColumnSortMode.Automatic;
dataGridView1.ColumnHeadersHeightSizeMode =
DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridView1.Columns["CatAirLinFarId"].HeaderText = "CatAirLinFarId";
dataGridView1.Columns["CatAirLinFarName"].HeaderText = "CatAirLinFarName";
dataGridView1.Columns["CCAut"].HeaderText = "CCAut";
dataGridView1.Columns["CCMan"].HeaderText = "CCMan";
dataGridView1.Columns["Cash"].HeaderText = "Cash";
dataGridView1.Columns["PMix"].HeaderText = "PMix";
dataGridView1.Columns["Misc"].HeaderText = "Misc";
List <AirLinesFare> list = AirLinesFareBL.GetAirLinesFare();
foreach (AirLinesFare item in list)
{
dataGridView1.Rows.Add(new object[] { item.CatAirLinFarId, item.CatAirLinFarName, item.CCAut, item.CCMan, item.Cash, item.PMix, item.Misc });
}
}
