private void Butikkdata_Load(object sender, EventArgs e) { var mySql = new mySql(); mySql.loadButikk(x); dataGridViewTest.DataSource = bindingSourceOrders; mySql.GetData(mySql.loadButikkStatement, bindingSourceOrders); for (int c = 0; c < dataGridViewTest.Columns.Count; ++c) { dataGridViewTest2.Columns.Add(dataGridViewTest.Columns[c].HeaderText, dataGridViewTest.Columns[c].HeaderText); } int Nindex = 0; for (int i = 0; i < dataGridViewTest.Rows.Count; i++)//each row { if (i < 1) { dataGridViewTest2.Rows.Add(); for (int j = 0; j < dataGridViewTest.Columns.Count; ++j)//each cell in row { dataGridViewTest2.Rows[Nindex].Cells[j].Value = dataGridViewTest.Rows[i].Cells[j].Value; } Nindex++; } else { if (dataGridViewTest.Rows[i].Cells["plu"].Value.ToString() == dataGridViewTest.Rows[i - 1].Cells["plu"].Value.ToString() & dataGridViewTest.Rows[i].Cells["farm"].Value.ToString() == dataGridViewTest.Rows[i - 1].Cells["farm"].Value.ToString())//if above is the same { dataGridViewTest2.Rows[Nindex - 1].Cells["stems"].Value = Convert.ToInt32(dataGridViewTest2.Rows[Nindex - 1].Cells["stems"].Value) + Convert.ToInt32(dataGridViewTest.Rows[i].Cells["stems"].Value); dataGridViewTest2.Rows[Nindex - 1].Cells["buckets"].Value = Convert.ToInt32(dataGridViewTest2.Rows[Nindex - 1].Cells["stems"].Value) / Convert.ToInt32(dataGridViewTest2.Rows[Nindex - 1].Cells["Stems pr bunch"].Value) / Convert.ToInt32(dataGridViewTest2.Rows[Nindex - 1].Cells["Bunch pr bucket"].Value); } else { dataGridViewTest2.Rows.Add(); for (int j = 0; j < dataGridViewTest.Columns.Count; ++j)//each cell in row { dataGridViewTest2.Rows[Nindex].Cells[j].Value = dataGridViewTest.Rows[i].Cells[j].Value; } Nindex++; } } } dataGridViewTest2.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("arial", 7); dataGridViewTest2.Columns[0].Visible = false; dataGridViewTest2.Columns[1].Visible = false; dataGridViewTest2.Columns[2].Visible = false; dataGridViewTest2.Columns[3].Visible = false; dataGridViewTest2.Columns["variety"].Visible = false; dataGridViewTest2.Columns["length"].Width = 45; dataGridViewTest2.Columns["mix"].Width = 45; dataGridViewTest2.Columns["sleeve"].Width = 80; dataGridViewTest2.Columns["with sleeves"].Width = 40; dataGridViewTest2.Columns["fairtrade"].Width = 40; dataGridViewTest2.Columns["bunch pr bucket"].Width = 40; dataGridViewTest2.Columns["stems pr bunch"].Width = 40; dataGridViewTest2.Columns["plu"].Width = 50; //dataGridViewTest2.Columns["boxes"].Visible = false; dataGridViewTest2.Columns["stems"].Width = 45; //dataGridViewTest2.Columns["price"].Width = 45; dataGridViewTest2.Columns["buckets"].Width = 45; mySql.fillupLabelsButikk(lblOrdreNumber, lblDeparture, lblArrival, lblDatecode, lblAmountStems, lblAmountBuckets, dataGridViewTest2); lblOrderNumberTitle.Text = lblOrdreNumber.Text; }