DataSet,OleDbConnection 等对象创建后，退出时要不销毁的？？

[whizstorm]

如：
Dim myCommand As OleDbCommand = New OleDbCommand()
Dim str As String = "Delete * From Project where ID = " & i.ToString
OleDbConnection1.Open()
myCommand = New OleDbCommand(str, OleDbConnection1)
myCommand.ExecuteNonQuery()
myCommand要不要在程序中销毁的，如有可能请讲一下，VB.net的销毁原理，谢谢

[smallMage]

当然要哦。myCommand.close()
OleDbConnection1.close()
顺序不能颠倒，不销毁占用资源

[rustical]

一般标准写法：
Dim myCommand As OleDbCommand = New OleDbCommand()
Dim str As String = "Delete * From Project where ID = " & i.ToString

try
OleDbConnection1.Open()
myCommand = New OleDbCommand(str, OleDbConnection1)
myCommand.ExecuteNonQuery()
catch ex as exction
'错误处理
finally
mycommand.dispose '可有可无
obldbconnection1.close
end try

GC 垃圾回收是自动，对于外部资源需要手工清理！
数据库连接就需要手工清理！
mycommand 一般不需要，当然清理也可以！

[whizstorm]

DataSet 对象呢，比如 Dim myds As DataSet 怎样销毁呢？？

[daisy8675]

dataset不用的