DataGridView / ComboBox (DataGridViewComboBoxColumn) สร้าง DataSource ให้กับ ComboBox (VB.Net , C#)

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

        '*** Master Data Table ***'
        ' Create Datable
        Dim dtTable As DataTable = New DataTable("myTable")
        ' Create Column Header
        dtTable.Columns.Add(New DataColumn("ColID", GetType(Integer)))
        dtTable.Columns.Add(New DataColumn("ColFullName", GetType(String)))
        dtTable.Columns.Add(New DataColumn("ColPoint", GetType(Integer)))
        dtTable.Columns.Add(New DataColumn("ColCountryCode", GetType(String)))
        ' Add Rows
        dtTable.Rows.Add(1, "Weerachai Nukitram", 10, "TH")
        dtTable.Rows.Add(2, "Wisarut Nukitram", 20, "US")
        dtTable.Rows.Add(3, "Wipa Nukitram", 30, "TH")

        '*** Country Data Table ***'
        ' Create Datable
        Dim dtCountry As DataTable = New DataTable("myCountry")
        dtCountry.Columns.Add(New DataColumn("ColCountryCode", GetType(String)))
        dtCountry.Columns.Add(New DataColumn("ColCountryName", GetType(String)))
        ' Add Rows
        dtCountry.Rows.Add("TH", "Thailand")
        dtCountry.Rows.Add("US", "United States")

        ' Bind to DataGridView
        Me.myDataGridView.AutoGenerateColumns = False
        Me.myDataGridView.AllowUserToAddRows = False
        Me.myDataGridView.DataSource = dtTable

        ' Bind ComboBox
        Me.COUNTRY.DataPropertyName = "Name"
        Me.COUNTRY.DataSource = dtCountry
        Me.COUNTRY.ValueMember = "ColCountryCode"
        Me.COUNTRY.DisplayMember = "ColCountryName"

        ' Loop defult selected from Datatable
        For Each row As DataGridViewRow In Me.myDataGridView.Rows
            Dim sel As DataRow = dtTable.Select("ColID = '" & row.Cells("ID").Value & "' ").FirstOrDefault()
            If Not (IsNothing(sel)) Then
                row.Cells("COUNTRY").Value = sel.Item("ColCountryCode")
            End If
        Next

        ' Summary Total Point
        Dim iTotal As Integer
        For Each row As DataGridViewRow In Me.myDataGridView.Rows
            iTotal = iTotal + row.Cells("POINT").Value
        Next
        Me.lblTotalPoint.Text = String.Format("Total Point : {0}", iTotal)

    End Sub

        private void Form1_Load(object sender, EventArgs e)
        {
            //*** Master Data Table ***'
            // Create Datable
            DataTable dtTable = new DataTable("myTable");

            //Create Column Header
            dtTable.Columns.Add(new DataColumn("ColID", typeof(int)));
            dtTable.Columns.Add(new DataColumn("ColFullName", typeof(string)));
            dtTable.Columns.Add(new DataColumn("ColPoint", typeof(int)));
            dtTable.Columns.Add(new DataColumn("ColCountryCode", typeof(string)));
            // Add Rows
            dtTable.Rows.Add(1, "Weerachai Nukitram", 10, "TH");
            dtTable.Rows.Add(2, "Wisarut Nukitram", 20, "US");
            dtTable.Rows.Add(3, "Wipa Nukitram", 30, "TH");

            //*** Country Data Table ***'
            // Create Datable
            DataTable dtCountry = new DataTable("myCountry");
            dtCountry.Columns.Add(new DataColumn("ColCountryCode", typeof(string)));
            dtCountry.Columns.Add(new DataColumn("ColCountryName", typeof(string)));
            // Add Rows
            dtCountry.Rows.Add("TH", "Thailand");
            dtCountry.Rows.Add("US", "United States");

            // Bind to DataGridView
            this.myDataGridView.AutoGenerateColumns = false;
            this.myDataGridView.AllowUserToAddRows = false;
            this.myDataGridView.DataSource = dtTable;

            // Bind ComboBox
            this.COUNTRY.DataPropertyName = "Name";
            this.COUNTRY.DataSource = dtCountry;
            this.COUNTRY.ValueMember = "ColCountryCode";
            this.COUNTRY.DisplayMember = "ColCountryName";

            // Loop defult selected from Datatable
            foreach (DataGridViewRow row in this.myDataGridView.Rows)
            {
                DataRow sel = dtTable.Select("ColID = '" + row.Cells["ID"].Value.ToString() + "' ").FirstOrDefault();
                if (sel != null)
                {
                    row.Cells["COUNTRY"].Value = sel["ColCountryCode"].ToString();
                }
            }

            // Summary Total Point
            int iTotal = 0;
            foreach (DataGridViewRow row in this.myDataGridView.Rows)
            {
                iTotal = iTotal + Convert.ToInt32(row.Cells["POINT"].Value);
            }
            this.lblTotalPoint.Text = String.Format("Total Point : {0}", iTotal);

        }

        ' Bind ComboBox
        Me.COUNTRY.DataPropertyName = "Name"
        Me.COUNTRY.DataSource = dtCountry
        Me.COUNTRY.ValueMember = "ColCountryCode"
        Me.COUNTRY.DisplayMember = "ColCountryName"

        ' Loop defult selected from Datatable
        For Each row As DataGridViewRow In Me.myDataGridView.Rows
            Dim sel As DataRow = dtTable.Select("ColID = '" & row.Cells("ID").Value & "' ").FirstOrDefault()
            If Not (IsNothing(sel)) Then
                row.Cells("COUNTRY").Value = sel.Item("ColCountryCode")
            End If
        Next