안녕하세요~! 곧 설날이네요! 다들 새해복 많이 받으세요
DataGridview에 MDB파일을 출력하는 폼을 만들었어요~
저는 DataGridview하나에 쿼리 하나를 넣어서 만들었는데 그러다 보니 코드가 너무 길어져서 이것을 함수나 ArrayList에 넣어 간단하게 줄일 수 있을꺼 같은데
가능 할까요? 함수를 만든다면 어떤 식으로 만들면 좋을까요??
// 코드
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;" + @"Data Source = C:\\ALIGNMENT.mdb"); //ALIGMENT(os 32bit));
DataGridView[] GView = new DataGridView[7];
private void Form2_Load(object sender, EventArgs e)
{
{//車?規格値
conn.Open();
dataGridView3.ColumnCount = 10;
dataGridView3.ColumnHeadersVisible = true;
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
dataGridView3.Columns[0].Name = "車種コ?ド";
dataGridView3.Columns[1].Name = "車種名1";
dataGridView3.Columns[2].Name = "前左車高測定点X座標";
dataGridView3.Columns[3].Name = "前左車高測定点Y座標";
dataGridView3.Columns[4].Name = "前右車高測定点X座標";
dataGridView3.Columns[5].Name = "前右車高測定点Y座標";
dataGridView3.Columns[6].Name = "後左車高測定点X座標";
dataGridView3.Columns[7].Name = "後左車高測定点Y座標";
dataGridView3.Columns[8].Name = "後右車高測定点X座標";
dataGridView3.Columns[9].Name = "後右車高測定点Y座標";
OleDbCommand comm = new OleDbCommand();
comm.CommandText = "SELECT * FROM CAR_MODL_CODE_MST INNER JOIN HEIGHT_STANDARD_VALUE_MST ON CAR_MODL_CODE_MST.CAR_MODEL_CODE = HEIGHT_STANDARD_VALUE_MST.CAR_MODEL_CODE";
comm.Connection = conn;
//OleDbDataReader reader = comm.ExecuteReader();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = comm;
DataSet ds = new DataSet();
oda.Fill(ds, "data");
dataGridView3.DataSource = ds.Tables[0];
conn.Close();
}
{//基本情報
conn.Open();
dataGridView8.ColumnCount = 6;
dataGridView8.ColumnHeadersVisible = true;
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
dataGridView8.Columns[0].Name = "車種コ?ド";
dataGridView8.Columns[1].Name = "車種名1";
dataGridView8.Columns[2].Name = "車種名2";
dataGridView8.Columns[3].Name = "車?形式";
dataGridView8.Columns[4].Name = "タイヤサイズ";
dataGridView8.Columns[5].Name = "ハンドル";
OleDbCommand comm = new OleDbCommand();
comm.CommandText = "SELECT * FROM CAR_MODL_CODE_MST INNER JOIN VEHICLE_EQUIPMENT_BASIS_MST ON CAR_MODL_CODE_MST.CAR_MODEL_CODE = VEHICLE_EQUIPMENT_BASIS_MST.CAR_MODEL_CODE";
comm.Connection = conn;
//OleDbDataReader reader = comm.ExecuteReader();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = comm;
DataSet ds = new DataSet();
oda.Fill(ds, "data");
dataGridView8.DataSource = ds.Tables[0];
conn.Close();
}
{//ロボット
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.CommandText = "SELECT * FROM CAR_MODL_CODE_MST INNER JOIN ROBOT_MST ON CAR_MODL_CODE_MST.CAR_MODEL_CODE = ROBOT_MST.CAR_MODEL_CODE";
comm.Connection = conn;
//OleDbDataReader reader = comm.ExecuteReader();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = comm;
DataSet ds = new DataSet();
oda.Fill(ds, "data");
dataGridView4.DataSource = ds.Tables[0];
conn.Close();
}
{//レ?ザ?センサ
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.CommandText = "SELECT * FROM CAR_MODL_CODE_MST INNER JOIN LASER_SENSOR_MST ON CAR_MODL_CODE_MST.CAR_MODEL_CODE = LASER_SENSOR_MST.CAR_MODEL_CODE";
comm.Connection = conn;
//OleDbDataReader reader = comm.ExecuteReader();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = comm;
DataSet ds = new DataSet();
oda.Fill(ds, "data");
dataGridView9.DataSource = ds.Tables[0];
conn.Close();
}
//
[최초 등록일: ]
[최종 수정일: 1/31/2019]