Code A

Oops...I originally posted this in wrong forum

I have an ADODC control bound to DataGrid and I am trying to update it but it will not let me.

Here is an example of my code...any ideas why this doesn't work?

'Connect and Retrieve Data using Jet 4.0


SQL = "SELECT * FROM table WHERE PrimaryID = " & PrimaryID & " ;"
Adodc1.CursorLocation = adUseClient
Adodc1.LockType = adLockOptimistic
Adodc1.CursorType = adOpenStatic
Adodc1.RecordSource = SQL
Adodc1.Refresh

Set DataGrid1.DataSource = Adodc1
DataGrid1.AllowUpdate = True


'Update Datagrid after Edit


Adodc1.Refresh
Datagrid1.Refresh

Thinker

What error do you get, and do you have some code in that tries
to do the update, or are you just relying on navigating to another
record to trigger the update?

Code A

i was relying on it automatically updating. i thought that was how .allowupdate worked, no?

how do you get the contents of the cell to manually add the update by code?

btw, i'm not getting any errors. it's just not accepting the update in the database.

Thinker

The allowupdate means it allows update, but for the update to
happen, you would need to navigate to a different row.

vikky17

Allowupdate method will just allow the datgrid to be updated if you want to upodate the the database you will have tp directlysave the Recordset by picking it upo fro the adodc

Code A

OK, ignore my first post.

New question....

How do I grab the text out of a cell of a datagrid? is this possible?

I have a datagrid set up with only 4 columns and 1 row. If the user enters data into a field, can i grab the data out of the cell...OR how do navigate the next row if there is only 1 record?

Thanks

praveensg

u can use the cellvalue method i guess