private void textBox1_KeyUp(object sender, KeyEventArgs e)
{
if (textBox1.Text.Trim().Equals(""))
{
MetodosPerfiles m = new MetodosPerfiles();
m.MostrarPerfiles(dataGridView1);
return;
}
else
{
String Cad = "%" + textBox1.Text + "%";
if (comboBox1.SelectedIndex == 0)
{
String query = " Select *From Candidatos_Perfiles WHERE [Nombre] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 1)
{
String query = "Select *From Candidatos_Perfiles WHERE [Apellido] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 2)
{
String query = "Select *From Candidatos_Perfiles WHERE [Tipo] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 3)
{
String query = "Select *From Candidatos_Perfiles WHERE [Sexo] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 4)
{
String query = "Select *From Candidatos_Perfiles WHERE [Procedencia] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 5)
{
String query = "Select *From Candidatos_Perfiles WHERE [Color del pelo] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
else if (comboBox1.SelectedIndex == 6)
{
String query = "Select *From Candidatos_Perfiles WHERE [Color de los ojos] like '" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(query, dataGridView1);
}
}
}//
private void textBox2_KeyUp(object sender, KeyEventArgs e)
{
if (textBox2.Text.Trim().Equals(""))
{
m = new MetodosCasting();
m.MostrarAgentes(dataGridView2);
return;
}
else
{
String Cad = "%" + textBox2.Text + "%";
if (comboBox2.SelectedIndex == 0)
{
String Query = "SELECT *FROM MostrarAgentes WHERE [Estado]='Activo' AND [# de Empleado] like'" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(Query, dataGridView2);
}
else if (comboBox2.SelectedIndex == 1)
{
String Query = "SELECT *FROM MostrarAgentes WHERE [Estado]='Activo' AND [Cédula] like'" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(Query, dataGridView2);
}
else if (comboBox2.SelectedIndex == 2)
{
String Query = "SELECT *FROM MostrarAgentes WHERE [Estado]='Activo' AND [Nombre] like'" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(Query, dataGridView2);
}
else if (comboBox2.SelectedIndex == 3)
{
String Query = "SELECT *FROM MostrarAgentes WHERE [Estado]='Activo' AND [Apellido] like'" + Cad + "'";
MetodosNav nav = new MetodosNav();
nav.Buscar(Query, dataGridView2);
}
} ///
} //
