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