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