private void RefreshDataGrid()
{
conexion = new ConexionPeliculas();
DataTable table = conexion.ConsultAll();
dataGridView1.DataSource = table;
}
private void LoadCBoxPeliculas()
{
ConexionPeliculas conexionPeliculas = new ConexionPeliculas();
IdNameDic = conexionPeliculas.ConsultIdName();
foreach (string i in IdNameDic.Values)
{
cBox.Items.Add(i);
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name.Contains("idPelicula"))
{
DataGridViewComboBoxCell comboBP = new DataGridViewComboBoxCell();
dataGridView1[e.ColumnIndex, e.RowIndex] = comboBP;
comboBP.Style.BackColor = SystemColors.Control;
comboBP.Style.SelectionBackColor = SystemColors.Control;
comboBP.Style.SelectionForeColor = SystemColors.Control;
ConexionPeliculas conexionP = new ConexionPeliculas();
Dictionary <int, string> dic = new Dictionary <int, string>();
DataTable table = new DataTable();
table.Columns.Add("idPelicula", typeof(int));
dic = conexionP.ConsultIdName();
foreach (int i in dic.Keys)
{
table.Rows.Add(i);
}
comboBP.ValueMember = "idPelicula";
comboBP.DisplayMember = "idPelicula";
comboBP.DataSource = table;
}
}
public FormInsertMovie()
{
InitializeComponent();
conexion = new ConexionPeliculas();
}
public FormMovies()
{
InitializeComponent();
conexion = new ConexionPeliculas();
RefreshDataGrid();
}
