Problem with ADO data control Update query

[neo008]

Hi All,

I have built up an adodc connnection and using it through connection strings.

I'm facing problem with update query-

code looks like-

adodc1.recordource="update products set stock=" & NewStock & " where product_id=" & proid & ""

adodc1.refresh

Though It gives error at refresh command, data is updated successfully.
if i dont refresh datacontrol it does not give error nor update anything.

error message is "OPERATION IS NOT ALLOWED WHEN THE OBJECT IS CLOSED"

can somebody help me out regarding this

-NE☼