So I was making a calculator that pulls from a mySQL database. The program works flawlessly on my personal computer. However, when I move the program to another computer it crashes upon loading.
If I take out my database call the program works so I believe I have localized it to this part of the code
Dim row as DataSet.PricesRow
For Each row In DataSet.Prices
Prices(count) = row.cost
test += vbNewLine & Prices(count)
count += 1
Next
Would adding this even make a difference?
Me.PricesTableAdapter.Fill(Me.DataSet.Prices)
getData()
'This is what was added:
Me.PricesTableAdapter.Connection.Close()
I am still fairly new to database linking so there are things I don't know. Would I even need to manually close the data connection after I get my information? If I need to post more I can.