469,125 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

Datagrid control with Adodc?

Hi All!, I have a problem refreshing data on the Datagrid control. I execute
sql statement directly using the ADODC control and try to make it updated
onto the Datagrid control, however, the Datagrid control is not updated with
new data... here is the flagment of codes:

sql = "update MyTable set Col1='test' where Col1='nodata'"
adoMain.Recordset.ActiveConnection.Execute sql
adoMain.Refresh
Set dgdMain.DataSource = adoMain
dgdMain.Refresh

pls tell me what I did wrong... thanks
Jul 17 '05 #1
1 3588
Ariane
2
try adding the line

dgdMain.DataChanged = True

after all that you put there.
Jun 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.