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!