private void RefreshDataGrid()
{
DataTable table = new DataTable();
conexion = new ConexionHorarios();
table = conexion.ConsultAll();
dataGridView1.DataSource = table;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name.Contains("idHorario"))
{
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;
ConexionHorarios conexionH = new ConexionHorarios();
int[] ids;
DataTable table = new DataTable();
table.Columns.Add("idHorario", typeof(int));
ids = conexionH.ConsultIds();
foreach (int i in ids)
{
table.Rows.Add(i);
}
comboBP.ValueMember = "idHorario";
comboBP.DisplayMember = "idHorario";
comboBP.DataSource = table;
}
else if (dataGridView1.Columns[e.ColumnIndex].Name.Contains("idCliente"))
{
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;
ConexionClientes conexionC = new ConexionClientes();
int[] ids;
DataTable table = new DataTable();
table.Columns.Add("idCliente", typeof(int));
ids = conexionC.ConsultIds();
foreach (int i in ids)
{
table.Rows.Add(i);
}
comboBP.ValueMember = "idCliente";
comboBP.DisplayMember = "idCliente";
comboBP.DataSource = table;
}
}
void LoadCombos()
{
ConexionClientes conexionClientes = new ConexionClientes();
ConexionHorarios conexionHorarios = new ConexionHorarios();
int[] idsClientes = conexionClientes.ConsultIds();
for (int i = 0; i < idsClientes.Length; i++)
{
cBoxClientes.Items.Add(idsClientes[i]);
}
int[] idsHorarios = conexionHorarios.ConsultIds();
for (int i = 0; i < idsHorarios.Length; i++)
{
comboBoxHorario.Items.Add(idsHorarios[i]);
}
}
public FormSchedule()
{
InitializeComponent();
conexion = new ConexionHorarios();
RefreshDataGrid();
}
