bmiles20001 0 Newbie Poster

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.