Binding Manager (update record problem)

[Agnes]

Binding Manager (update problem) by agnescheng
I use binding Manager to bind the textbox, I got a problem on update record.
E.g Me.txtUserId.Text = "PETER"
bm.current.item("userid") = Me.txtUserId.Text.
if ds.haschanges() then
....................
.....acceptchanges()
messagebox.show("Save is completed")
end if................
I found that Messagebox is showed, BUT the userid is still the old value.
WHY ?
Then I test that bm.current.item("userid") = "PETER" . <- IT CAN UPDATE THE
RECORD.
OR Dim strUserId as string = Me.txtUserId.text
bm.current.item("userid") = strUserId <-- It can update the record
also.

[Ken Tucker [MVP]]

Hi,

You never used begin and end edit

bm.current.beginedit
bm.current.item("userid") = Me.txtUserId.Text.
bm.current.endedit

http://msdn.microsoft.com/library/de...nedittopic.asp
Ken
------------------

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:OS****************@TK2MSFTNGP12.phx.gbl...
Binding Manager (update problem) by agnescheng
I use binding Manager to bind the textbox, I got a problem on update record.
E.g Me.txtUserId.Text = "PETER"
bm.current.item("userid") = Me.txtUserId.Text.
if ds.haschanges() then
....................
.....acceptchanges()
messagebox.show("Save is completed")
end if................
I found that Messagebox is showed, BUT the userid is still the old value.
WHY ?
Then I test that bm.current.item("userid") = "PETER" . <- IT CAN UPDATE THE
RECORD.
OR Dim strUserId as string = Me.txtUserId.text
bm.current.item("userid") = strUserId <-- It can update the record
also.

[Agnes]

i use Endcurrentedit already ??

"Ken Tucker [MVP]" <vb***@bellsouth.net> ¼¶¼g©ó¶l¥ó·s»D:%2****************@TK2MSFTNGP14.phx .gbl...

Hi,

You never used begin and end edit

bm.current.beginedit
bm.current.item("userid") = Me.txtUserId.Text.
bm.current.endedit

http://msdn.microsoft.com/library/de...nedittopic.asp
Ken
------------------

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:OS****************@TK2MSFTNGP12.phx.gbl...
Binding Manager (update problem) by agnescheng
I use binding Manager to bind the textbox, I got a problem on update
record.
E.g Me.txtUserId.Text = "PETER"
bm.current.item("userid") = Me.txtUserId.Text.
if ds.haschanges() then
....................
.....acceptchanges()
messagebox.show("Save is completed")
end if................
I found that Messagebox is showed, BUT the userid is still the old value.
WHY ?
Then I test that bm.current.item("userid") = "PETER" . <- IT CAN UPDATE
THE
RECORD.
OR Dim strUserId as string = Me.txtUserId.text
bm.current.item("userid") = strUserId <-- It can update the record
also.