1 2 3 4 5 6 7 8 9 10 11 12 13 14
| private void button1_Click(object sender, EventArgs e)
{
con.Open();
DataTable dt = new DataTable();
string query = "SELECT ETAT.Code_Produit, ETAT.Famille, ETAT.Marque, Sum(IIf([action]="acquisition" And "don",IIf([mouvement]="Entrée",[QUANTITE],-[QUANTITE]),0)) AS ACQUISITION, Sum(IIf([STOCK]="A",IIf([mouvement]="Entrée",[QUANTITE],-[QUANTITE]),0)) AS STOCK_A,"&
&"Sum(IIf([STOCK]="C",IIf([mouvement]="Entrée",[QUANTITE],-[QUANTITE]),0)) AS STOCK_C, Sum(IIf([STOCK]="D",IIf([mouvement]="'Entrée'",[QUANTITE],-[QUANTITE]),0)) AS STOCK_D, [ACQUISITION]-([STOCK_A]+[STOCK_C]+[STOCK_D]) AS STOCK_E FROM ETAT GROUP BY ETAT.Code_Produit,"&
&"ETAT.Famille, ETAT.Marque, ETAT.Famille, ETAT.Marque, ETAT.Designation";
OleDbDataAdapter sda = new OleDbDataAdapter(query, con);
sda.Fill(dt);
con.Close();
dataGridView1.DataSource = dt;
textBox2.Text = dt.Rows.Count.ToString(); |
Partager