//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();
}
