public void updateFarmsForm()
{
var mySql = new mySql();
int y = Convert.ToInt32(dataGridViewFarms.Rows[dataGridViewFarms.CurrentRow.Index].Cells[1].Value);
mySql.loadOneFarm(x, y);
dataGridViewFarmBestilling.DataSource = bindingSourceOrders2;
mySql.GetData(mySql.farmsLoadOneFarmStatement, bindingSourceOrders2);
lblOrdreNumber.Text = dataGridViewFarmBestilling.Rows[0].Cells["order_number"].Value.ToString();
lblDeparture.Text = dataGridViewFarmBestilling.Rows[0].Cells["departure"].Value.ToString().Substring(0, 10);;
lblArrival.Text = dataGridViewFarmBestilling.Rows[0].Cells["arrival"].Value.ToString().Substring(0, 10);;
lblDatecode.Text = dataGridViewFarmBestilling.Rows[0].Cells["datecode"].Value.ToString();
int sumBoxes = 0;
decimal sumPrice = 0;
for (int i = 0; i < dataGridViewFarmBestilling.Rows.Count; ++i)
{
sumBoxes += Convert.ToInt32(dataGridViewFarmBestilling.Rows[i].Cells["boxes"].Value);
sumPrice += Convert.ToDecimal(dataGridViewFarmBestilling.Rows[i].Cells["price"].Value);
}
lblAmountPrice.Text = sumPrice.ToString();
lblAmountBoxes.Text = sumBoxes.ToString();
dataGridViewFarmBestilling.Columns["variety"].Width = 200;
dataGridViewFarmBestilling.Columns["order_number"].Visible = false;
dataGridViewFarmBestilling.Columns["departure"].Visible = false;
dataGridViewFarmBestilling.Columns["arrival"].Visible = false;
dataGridViewFarmBestilling.Columns["datecode"].Visible = false;
dataGridViewFarmBestilling.Columns["farm"].Visible = false;
dataGridViewFarmBestilling.Columns["boxes"].DisplayIndex = 16;
}