= nothing?

[cBarry263]

I am writing a program that polls a database every 60 seconds. Do saying things like objDataAdapter = Nothing, objDataSet = Nothing actually do anything? And is this the proper way to free up these objects so the next time I poll the database (done with a timer1_elapsed method) these objects do not have values stored to them?

 

[ManicCW]

to destoy dataset or adapter use
ds.Dispose()

but to free them (i supose you are talking about clearing records) you can use
ds.Clear()
this removes all rows from all tables in dataset

 

[JuggaloBrotha]

if you close the connection, the dataadapters loose their dependency on the database, so all you have to do is clear the dataset:

Connection.Close()
dsDataSet.Clear()