yes, movie is a datarow.
i was told to arrange the loop so that the row is only handled once, then found and copied after.
the loop is written after the code i posted above.
think that would work?
here's the current loop:
vb Code:
Me.MoviesTableAdapter.Update(Me.PmrDataSet) Dim findmovies As DataRow Me.PmrDataSet.Members.PrimaryKey = New DataColumn() {Me.PmrDataSet.Movies.Columns("Title")} findmovies = Me.PmrDataSet.Members.Rows.Find(Me.txtTitle.Text) For Each findmovies In Me.PmrDataSet.Movies.Rows If findmovies.Item("Title") = Me.txtTitle.Text Then movieIdsfrm.lbxHidden.Items.Add(findmovies.Item("MovieId")) End If Next movieIdsfrm.Show()




Reply With Quote