DatagridView Row를 클릭하면 관련된 정보를 다른 datagridView에 표시하기

폼의 구성은 다음과 같이  두개의 Datagridview를 폼위에 올려 놓는 것입니다.

이제  DataGridView1_CellContentClick 이벤트를 작성합니다.

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
           
 
            string ID_1 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
          
            string DB_path = targetPath;
            DataSet ds = new DataSet();
 
 
            DataConn conn1 = new DataConn();
 
 
            string sql = @"SELECT Customers.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipAddress, Orders.ShipName, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry
                          FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
                          WHERE (((Customers.CustomerID)='" + ID_1 + "'))";
 
 
            ds = conn1.GetDataset(sql, DB_path);
 
           
          
            dataGridView2.DataSource = ds.Tables[0];
 
           
        }
 
 
 

결과는 다음과 같이 나타납니다.

어떻게 잘 되고 계신가여?

전체 코드는 다음과 같습니다.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;
 
namespace brog_1
{
    public partial class Form1 : Form
    {
        public string targetPath = Application.StartupPath + @"\Northwind.mdb";
 
        public Form1()
        {
            InitializeComponent();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
            DateTime aa = dateTimePicker1.Value;
            string date11 = aa.ToShortDateString();
 
            DataConn conn1 = new DataConn();
            DataSet ds;
            string DB_path = targetPath;
 
 
              string sql = @"SELECT * FROM Customers";
 
            ds = conn1.GetDataset(sql, DB_path);
            dataGridView1.DataSource = ds.Tables[0];
        }
 
        
 
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
           
 
            string ID_1 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
          
            string DB_path = targetPath;
            DataSet ds = new DataSet();
 
 
            DataConn conn1 = new DataConn();
 
 
            string sql = @"SELECT Customers.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipAddress, Orders.ShipName, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry
                          FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
                          WHERE (((Customers.CustomerID)='" + ID_1 + "'))";
 
 
            ds = conn1.GetDataset(sql, DB_path);
 
           
          
            dataGridView2.DataSource = ds.Tables[0];
 
           
        }
    }
 
    class DataConn
    {
        public DataSet GetDataset(string sql, string DB_path)
        {
            string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB_path + ";Jet OLEDB:Database Password=";
           
 
            OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr);
            DataSet ds = new DataSet();
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, conn);
            adp.Fill(ds);
            return ds;
 
        }
 
      
    }
}