Avatar of keicy01
keicy01

asked on 

Using Table Adapter in a Loop

I have a table adapter that I am using to retrieve data from a table using the GetDataBy method.
If I have just one item that I am searching, this works fine.  But when there is more than one item and I call the GetDataBy in a for loop, it always times out
after the first initial call.  At the end of the for loop, I call the dispose() method to release the datatable before calling the GetDataBy method again, but it
doesn't work.  What am I missing??  

--For Loop Starts Here
Dim tDocumentPartTA As New ATEXRevMergeDataSetTableAdapters.tDocumentPartTableAdapter
Dim versionInfo As New ATEXRevMergeDataSet.tDocumentPartDataTable

versionInfo = tDocumentPartTA.GetDataByVersionID(itemCurrentVersionID)
|
OTHER CODE HERE LOOPING THROUGH DATA TABLE
|
versionInfo.Dispose()

-NEXT

Your help would be tremendously appreciated
Thanks!
Visual Basic.NET

Avatar of undefined
Last Comment
Bob Learned

8/22/2022 - Mon