MSHflexgrid doesnt update after adodc changes databse HELP!

by Lifete » Tue, 26 Nov 2002 04:57:41

I have a MSHFlexgrid and a ADODC component in my program. When i change the
values in the database with the ADODC component, the MSHflexgrid component
doesnt give me the new database data on the screen. I have tried to refresh
both the adodc recordset and the flexgrid control. Then the flexgrid
controls doesnt show all the changed data. I checked the database and the
changes are realy made by the adodc. Can somebody help me, PLEASE!! I have
looked everywhere but i can't find the solution. THank you very much!

Bas van Dorenmalen

Top

1. MSHflexgrid doesnt update after adodc changes databse HELP!

Hi,

Create the same dataenvironment twice. Let's name them dte1 and dte2.
The flexgrid we call grd - bound to the dte1 at design time
After you updated the ADO-recordset, you switch the datasource for the
grid from one dataenvironment to the other

Private sub Form_Load()
if dte1.connection1.state = adClose then
dte1.connection1.open
end if

if dte1.command1.state = adClose then
dte1.command1.open
end if

' the same you do for dte2

dteString = "dte1"

End sub

' here comes the procedure to call at updating your recordset

Private sub doUpdateRecordset()

'do your thing with the fields of the recordset
adodc1.recordset.update

'to make sure
adodc1.recordset.requery

'and now.....!!!!1

set grd.datasource = Nothing
grd.datamember = "command1"

if dteString = "dte1" then
set grd.datasource=dte2
dteString = "dte2"
else
set grd.datasource=dte1
dteString="dte1"
end if