private void textBox2_KeyUp(object sender, KeyEventArgs e) { if (textBox2.Text.Trim().Equals("")) { MetodosCasting m = new MetodosCasting(); m.MostrarAgentes(dataGridView1); return; } else { String Cad = "%" + textBox2.Text + "%"; if (comboBox2.SelectedIndex == 0) { String Query = "SELECT *FROM MostrarAgentes WHERE [# de Empleado] like '" + Cad + "'"; MetodosNav nav = new MetodosNav(); nav.Buscar(Query, dataGridView1); } else if (comboBox2.SelectedIndex == 1) { String Query = "SELECT *FROM MostrarAgentes WHERE [Cédula] like '" + Cad + "'"; MetodosNav nav = new MetodosNav(); nav.Buscar(Query, dataGridView1); } else if (comboBox2.SelectedIndex == 2) { String Query = "SELECT *FROM MostrarAgentes WHERE [Nombre] like '" + Cad + "'"; MetodosNav nav = new MetodosNav(); nav.Buscar(Query, dataGridView1); } else if (comboBox2.SelectedIndex == 3) { String Query = "SELECT *FROM MostrarAgentes WHERE [Apellido] like '" + Cad + "'"; MetodosNav nav = new MetodosNav(); nav.Buscar(Query, dataGridView1); } else if (comboBox2.SelectedIndex == 4) { String Query = "Select *From MostrarAgentes WHERE [Estado] like '" + Cad + "'"; MetodosNav nav = new MetodosNav(); nav.Buscar(Query, dataGridView1); } }/// }
private void EditarAgente_Load(object sender, EventArgs e) { MetodosCasting m = new MetodosCasting(); m.MostrarAgentes(dataGridView1); }