Update DataGrid with ADO

[dwong]

Hi,

I have a DataGrid bound to an ADO. I want to be able to update the DataGrid and have it automatically update the DB and reflected on the screen.

The ADO is set to CommandType = adCmdText, because I only want to display certain information from the DB.

The Database also have a primary key set.

(Q) How does the update occurs. If it is as simple as ado1.refresh, than which event will this need to be invoke from?

Thanks in advance...