Recherche Multi Critire langage c# visual studio (le projet connecter avec la base de donnees)
La forme de projet
Code source de la button Rechercher
private void button10_Click(object sender, EventArgs e)
{
DataTable dt1 = new DataTable();
// if (cnd1 || cnd2 || cnd3 || cnd4 & cnd5 & cnd6) MessageBox.Show("okkkkkkkkkkkk");
string a ="1=1";
string b = "1=1";
string c = "1=1";
string d = "1=1";
string f = "1=1";
string g = "1=1";
if (checkBox1.Checked == true) a = "id_emp='"+textBox1.Text+"'";
if (checkBox2.Checked == true) b = "nom_emp='" + textBox2.Text + "'";
if (checkBox3.Checked == true) c = "job_emp='" + textBox3.Text + "'";
if (checkBox4.Checked == true) d = "superviseur_emp='" + textBox4.Text + "'";
if (checkBox5.Checked == true) f = "id_dep='" + comboBox1.Text + "'";
if (checkBox6.Checked == true) g = "salaire_emp='" + textBox5.Text + "'";
cnx_new.opensql();
cnx_new.s = string.Format("select * from [employe] where " + a + " AND " + b + " AND " + c + " AND " + d + " AND " + f + " AND " + g + ""); //
SqlCommand cm5 = new SqlCommand(cnx_new.s, cnx_new.cnx1);
cnx_new.datard = cm5.ExecuteReader();
dt1.Load(cnx_new.datard);
dataGridView1.DataSource = dt1;
cnx_new.datard.Close();
cnx_new.closedsql();
}


Aucun commentaire