private void comp_data1_combobox_SelectionChangeCommitted(object sender, EventArgs e) { dataGridView1.Rows.Clear(); Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client(); this.dataGridView1.VirtualMode = true; click1 = true; string setNumber1 = comp_data1_combobox.SelectedItem as string; int count1 = comp_data1_combobox.Items.Count; string[] set1 = new string[count1]; set1 = setNumber1.Split('/'); strarr1 = client.Load_data_from_DB(set1[0]); this.dataGridView1.RowCount = strarr1.GetLength(0) + 1; if (click2 == true && click1 == true) { foreach (DataGridViewRow row in dataGridView2.Rows) { foreach (DataGridViewColumn col in dataGridView2.Columns) { dataGridView2.Rows[row.Index].Cells[col.Index].Style.BackColor = Color.White; } } compare(strarr1, strarr2, 0, dataGridView1, dataGridView2); compare(strarr1, strarr2, 1, dataGridView2, dataGridView1); //dataGridView2.Refresh(); } client.Close(); }
private void setNumber() { Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client(); int setNumCounts = client.Load_setNumbers().Length; string[] setNumbers = new string[setNumCounts]; setNumbers = client.Load_setNumbers(); comp_data1_combobox.Items.AddRange(setNumbers); comp_data2_combobox.Items.AddRange(setNumbers); client.Close(); }
private void colName(DataTable dt, DataGridView dgv) { Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client(); int columnCounts = client.Load_column_name().Length; //컬럼 개수 string[] columnName = new string[columnCounts]; //컬럼명 들어있는 string[] columnName = client.Load_column_name(); //컬럼이름 넣기 for (int i = 0; i < columnName.Length; i++) { dt.Columns.Add(columnName[i]); } dgv.DataSource = dt; client.Close(); }
private void addColum(DataGridView dgv) { Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client(); int columnCounts = client.Load_column_name().Length; //컬럼 개수 string[] columnName = new string[columnCounts]; //컬럼명 들어있는 string[] columnName = client.Load_column_name(); //컬럼이름 넣기 for (int i = 0; i < columnName.Length; i++) { DataGridViewTextBoxColumn Column = new DataGridViewTextBoxColumn(); Column.HeaderText = columnName[i].ToString(); Column.Name = columnName[i].ToString(); dgv.Columns.Add(Column); } client.Close(); }
//데이터 넣기 private void store(string item = "", DataTable dt = null, DataGridView dgv = null) { dt.Clear(); Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client(); int columnCounts = client.Load_data_from_DB(item).Length; string[] dataArr = new string[columnCounts]; dataArr = client.Load_data_from_DB(item); int col = client.Load_column_name().Length - 1; int row = columnCounts / col; string[,] data = new string[row, col]; for (int r = 0, index = 0; r < row; r++) { for (int c = 0; c < col; c++) { data[r, c] = dataArr[index]; index++; } } DataRow dr = null; for (int r = 0; r < row; r++) { dr = dt.Rows.Add(); for (int c = 0; c < col; c++) { dr[c + 1] = data[r, c]; } } client.Close(); }