OPRAG-OPREG

   For Each row As DataGridViewRow In DgvDETECTIONTESTINPUT.Rows                     Dim CmbBoxSize As DataGridViewComboBoxCell = CType((row.Cells(0)), DataGridViewComboBoxCell)                     CmbBoxSize.Items.Add(MejaData(row.Index)(1))                     CmbBoxSize.Value = MejaData(row.Index)(1)                 Next

this is how you gonna do that.. yes it is sometimes learning using tutorial book makes us boring.. so this tutorial is how to make it simple but very useful in understanding MVC5 & VB.Net Tutorial

VView (.vbhtml)               <div class="form-group">                      @Html.LabelFor(Function(model) model.Plant, "Plant",                          htmlAttributes:=New With {.class = "control-label col-md-2"})                      <div Class="col-md-10">                      @Html.DropDownList("MeSkill", New List(Of SelectListItem)() From                         {                             New SelectListItem() With {.Value = "1", .Text = "BKS"},                             New SelectListItem() With {.Value = "2", .Text = "KRW"},                             New SelectListItem() With {.Value = "3", .Text = "HO"}                         }, " -- Pilih Plant --", New With {.class = "form-control"})                      </div>                  </div>

Run your Visual Studio as Administrator account

                                Dim DS_ParentChild As New DataSet()                 DS_ParentChild.Tables.Add(DTMaterial)                 DS_ParentChild.Tables.Add(DTChild)                 'Relation                 DS_ParentChild.Relations.Add("MODEL",                                              DTMaterial.Columns("CODE"),                                              DTChild.Columns("CHILD")                                              )                 .DataSource = DS_ParentChild                 .ActiveSheet.Columns(0).DataField = "CODE"

Private Sub DATA_TOBE_SAVE()         OfdBUKAFILE.Filter = "*.xlsx|*.xlsx|All files(*.*)|*.*"         If OfdBUKAFILE.ShowDialog = Windows.Forms.DialogResult.OK Then             Try                 Conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & _                      "Data Source='" & OfdBUKAFILE.FileName & "';Extended Properties=Excel 12.0;")                 DA = New OleDbDataAdapter("SELECT * FROM [FIXED_ORDER_MONTHLY$]", Conn)                 DTTemp = New DataTable                 Conn.Open()                 DA.Fill(DTTemp)                 'Skip Datatable Rows.. ini skip 2 baris...                 Dim BarisBaru As IEnumerable(Of DataRow) = DTTemp.AsEnumerable().Skip(2)                 Dim DT As DataTable = BarisBaru.CopyToDataTable()                 'Skip Datatable Rows.. ini skip 2 baris...                 Dim DT_Check_Upload As New DataTable                 For Each t