//Client public void Afficher_Client(TransparentGrid grid) { cmd = new SqlCommand("SELECT code,nom,prenom,portable,tele,fax,ice,IFClient,email,adresse,ville,pays," + "respo_nom,type_societe,registre,patente,RS FROM infoClients", conn); adapt = new SqlDataAdapter(cmd); ds = new DataSet(); adapt.Fill(ds); grid.DataSource = ds.Tables[0]; }
public void Afficher_Client_ParFiltre(TransparentGrid grid, string ville) { cmd = new SqlCommand("SELECT code,nom,prenom,portable,tele,fax,ice,IFClient,email,adresse,ville,pays," + "respo_nom,type_societe,registre,patente,RS FROM infoClients where ville = @ville", conn); cmd.Parameters.AddWithValue("@ville", ville); adapt = new SqlDataAdapter(cmd); cmd.ExecuteNonQuery(); ds = new DataSet(); adapt.Fill(ds); grid.DataSource = ds.Tables[0]; cmd.Parameters.Clear(); }