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; }
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(); } } }
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]); } } }