Beispiel #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            ServiceFilteringClient client = new ServiceFilteringClient();
            DataTable  dt            = new DataTable("laptops");
            int        columnCount   = 0;
            List <int> columnNumbers = new List <int>();

            foreach (DataGridViewColumn dataGridViewColumn in dataGridView1.Columns)
            {
                if (dataGridViewColumn.Visible)
                {
                    dt.Columns.Add(dataGridViewColumn.Name);
                    columnNumbers.Add(columnCount);
                }
                columnCount++;
            }

            var cell = new object[columnNumbers.Count];

            foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows)
            {
                int i = 0;
                foreach (int a in columnNumbers)
                {
                    cell[i] = dataGridViewRow.Cells[a].Value;
                    i++;
                }
                dt.Rows.Add(cell);
            }
            dataGridView1.Rows.Clear();
            DataTable firtredValue = client.filteringBrand(dt, brandChoose);

            dataGridView1.Rows.Add();
            for (int i = 0; i < firtredValue.Rows.Count; i++)
            {
                dataGridView1.Rows.Add();
                for (int j = 0; j < firtredValue.Columns.Count; j++)
                {
                    dataGridView1.Rows[i].Cells[j].Value = firtredValue.Rows[i][j].ToString();
                }
            }
            laptopCount.Text = "Liczba laptopów: " + firtredValue.Rows.Count;
        }
Beispiel #2
0
        public void LoadDataFromDB()
        {
            ServiceFilteringClient client = new ServiceFilteringClient();
            DataTable dt = client.GetDataFromDataBase();

            dataGridView1.Rows.Clear();
            laptopCount.Text = "Liczba laptopów: " + dt.Rows.Count;
            dataGridView1.Rows.Add();
            int k = 0;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dataGridView1.Rows.Add();
                for (int j = 1, s = 0; j < dt.Columns.Count && s < dt.Columns.Count; j++, s++)
                {
                    dataGridView1.Rows[i].Cells[s].Value = dt.Rows[i][j].ToString();
                }
            }
        }
Beispiel #3
0
        public void AddAspectRation()
        {
            DataTable  dt            = new DataTable("laptops");
            int        columnCount   = 0;
            List <int> columnNumbers = new List <int>();

            foreach (DataGridViewColumn dataGridViewColumn in dataGridView1.Columns)
            {
                if (dataGridViewColumn.Visible)
                {
                    dt.Columns.Add(dataGridViewColumn.Name);
                    columnNumbers.Add(columnCount);
                }
                columnCount++;
            }

            var cell = new object[columnNumbers.Count];

            foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows)
            {
                int i = 0;
                foreach (int a in columnNumbers)
                {
                    cell[i] = dataGridViewRow.Cells[a].Value;
                    i++;
                }
                dt.Rows.Add(cell);
            }
            ServiceFilteringClient client = new ServiceFilteringClient();

            string[] list = client.aspectRatioList(dt);
            if (ScreenChooseComboBox.Items.Count == 0)
            {
                for (int i = 0; i < list.Length; i++)
                {
                    ScreenChooseComboBox.Items.Add(list[i]);
                }
            }
        }