Greetings everyone!

with adodc1
   .connectionstring = pConnection
   .recordsource = "select * from table"
   .refresh
end with
set datagrid1.datasource = adodc1

the above set of commands work for me.
the question is, how do i clear the contents of the adodc1?

i tried setting the pConnection = nothing and
setting the datagrid1.datasouce = nothing

but i guess it did not do the trick

i am having problems with memory management because the ado eats up a lot of data space

please help. thanks

im a real novice at vb but have u tried

datagrid1.datasouce = 0

or

datagrid1.datasouce = ""

____________________________
[IMG]http://tinypic.com/m7b5tg.jpg[/IMG]

Adodc1.Recordset.Close


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

thanks to both of you.