Update a datagrid
I have a form in my application which selects data from th backend SQL server and brings it into a grid
This is the code I use to get the data
Dim sSQL As String
sSQL = "Select * from V_FundAllocation where projectID = " & gURN
cnn.CursorLocation = adUseClient
Set grd_FundAllocation.DataSource = GetRecordset(sSQL)
This is working fine
however, even though the datagrid property AllowUpdate is set to true, when I change a value in my datagrid, this is not saved back to SQL.
I tried out
but this is not right, can anyone tell me th correct way to update the changes in the grid.