Insert Data & Sub Data Into MS Access
Dim dr As DataRowdr = Me.DATABASEDataSet.TABLE1.NewRowdr(“FIELD1”) = Me.TextBox1.Textdr(“FIELD2”) = Me.NumericUpDown1.ValueMe.DATABASE.TABLE1.Rows.Add(dr)Me.TABLE1TableAdapter.Update(Me.DATABASEDataSet.TABLE1)Me.TABLE1TableAdapter.Fill(Me.DATABASEDataSet.TABLE1) Dim i As Integer, ID As IntegerDim dr2 As DataRow()dr2 = Me.DATABASEDataSet.TABLE1.Select(“”, “IDDESC”)StudentPK = dr2(0)(“ID”)For i = 0 To ListBox1.SelectedItems.Count – 1dr = Me.DATABASEDataSet.TABLE2.NewRowdr(“ID”) = IDdr(“FIELD1”) = Me.cbxRoute.SelectedValuedr(“FIELD2”) = (DirectCast(Me.ListBox1.SelectedItems(i), DataRowView)(0).ToString)dr(“FIELD3”) = Me.NumericUpDown1.ValueMe.DATABASEDataSet.TABLE2.Rows.Add(dr)NextMe.TABLE2TableAdapter.Update(Me.DATABASEDataSet.TABLE2)Me.TABLE2TableAdapter.Fill(Me.DATABASEDataSet.TABLE2)