Release DB Table from Memory
I know what the following lines do:
Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=" & DBFileName
Dim sqlStr As String = "SELECT * FROM " & DBTableName
Dim conn As OleDbConnection = New OleDbConnection(conStr)
Dim da As OleDbDataAdapter = New OleDbDataAdapter(sqlStr, conn)
adapter's Fill method
Dim ds As DataSet = New DataSet
da.Fill(ds, DBTable)
But what is the following line do for me?
' Attach dataset's DefaultView to the datagrid control
DataGrid1.DataSource = ds.DefaultViewManager
How do I release the DBTable from memory? It seems as if I fill da. then I can da.dispose but that doesn't work.
Thanks
Cathy
Jan 2004 - NEWBIE to VB6
Any and all help appreciated