Datagrid1

[united50]

if i try to search my datagrid twice it says.
Run time error '3705'
Operation not allowed when object is open.

      DataEnvironment1.command1 test & "%"

[QVeen72]

if i try to search my datagrid twice it says.
Run time error '3705'
Operation not allowed when object is open.

      DataEnvironment1.command1 test & "%"

Hi,

Before Passing the parameter, Close the Data Env's Connection Object:
[code=vb]
With DataEnvironment 1.Connection1
If .State = adStateOpen Then .Close
.Open
.Command1 test & "%"
End With
[/code]

REgards
Veena

[debasisdas]

Don't forget to close the connection after database related activity is over. Its even beter to try to open the connections if it already not opened.