datagrid refresh

[matcathy]

Hi all,

I use the data environment to retreive data from db and put them onto a datagrid.

everytime I start my application and the old result from the last time will also display on the datagrid. Seems like the result stays in memory!!!

someone suggest me to refresh my dataconection like
Data1.refresh

my data environment name is 'DEMAIN'
and the connection is named 'CONNECTION1'
I tried but found no such refresh command for them
the only thing I can refresh is the datagrid but it's not earsing the previous result.

Any suggestion?
Many thanks.

[compuGEEK]

Hello,

Make sure to close all connections and set them equal to nothing. This can be done immediately after the DataEnvironment executes the query and retrieves your data.

For example:


YourDataEnvironment.YourConnection.Close
Set YourDataEnvironment = Nothing

CompuGEEK



------------------