private void btSupprimerArticle_Click(object sender, EventArgs e)
{
string id_panier = "";
foreach (DataGridViewRow Lig in dgvPanier.SelectedRows)
{
id_panier = dgvPanier.Rows[Lig.Index].Cells["id"].Value.ToString();
}
Requete_Sql = "delete from panier where id = '" + id_panier + "'";
sc.AjoutSupModifPanierSql(Requete_Sql);
RafraichirPanier();
}
private void btPanier_Click(object sender, EventArgs e)
{
int lig = dgvArticle.CurrentCell.OwningRow.Index;
Id_Produit = dgvArticle.Rows[lig].Cells["Id"].Value.ToString();
Requete_Sql = @"insert into panier (id,id_produit,quantite,panier.prix_vente,id_client) select null,id as id_produit,1,prix_vente," + PageAcceuil.NumUtilisateur + " from produit where id = " + Id_Produit;
sc.AjoutSupModifPanierSql(Requete_Sql);
this.Close();
}