dataGridView1.Columns.Add("test","");
                    dataGridView1.Columns.Add("nomenclature_id", "код номенклатуры");
                    dataGridView1.Columns.Add("name", "наименование");
                    dataGridView1.Columns.Add("price", "цена");
                    dataGridView1.Columns.Add("availiable_amount", "в наличии");

                    connection.Open();
                    MySqlDataAdapter[] da = new MySqlDataAdapter[wh_count];
                    DataSet[] ds = new DataSet[wh_count];
                    MySqlCommand[] getTable = new MySqlCommand[wh_count];

                    for (int count = 0; count <= wh_count - 1; count++)
                    {
                        dataGridView1.Rows.Add("cклад " + (count + 1).ToString() +":");
                        getTable[count] = new MySqlCommand("SELECT availiable_nomenclature.nomenclature_id, name, price, availiable_amount FROM availiable_nomenclature INNER JOIN nomenclature ON availiable_nomenclature.nomenclature_id = nomenclature.nomenclature_id WHERE warehouse_number =" + (count + 1).ToString(), connection);
                        da[count] = new MySqlDataAdapter();
                        da[count].SelectCommand = getTable[count];
                        ds[count] = new DataSet();
                        da[count].Fill(ds[count],"AVNOM");
                        row = ds[count].Tables["AVNOM"].Rows.Count - 1;
                        dbRow = 0;

                        for (int r = lastRow; r <= lastRow + row; r++)
                        {
                            dataGridView1.Rows.Add();
                            dataGridView1.Rows[r].Cells[1].Value = ds[count].Tables["AVNOM"].Rows[dbRow].ItemArray[0];
                            dataGridView1.Rows[r].Cells[2].Value = ds[count].Tables["AVNOM"].Rows[dbRow].ItemArray[1];
                            dataGridView1.Rows[r].Cells[3].Value = ds[count].Tables["AVNOM"].Rows[dbRow].ItemArray[2];
                            dataGridView1.Rows[r].Cells[4].Value = ds[count].Tables["AVNOM"].Rows[dbRow].ItemArray[3];
                            dbRow++;
                        }
                        lastRow += row + 2;
                    }
                    connection.Close();