ADO.NET 2.0 Question - LearnVisualStud io.Net tutorial

[Mike W]

I ran though the ADO.NET tutorials on www.LearnVisualStudio.Net (also
available from msdn.microsoft. com) for VB 2005 - specifically lesson 9 of
"Visual Basic 2005 Express Edition for Beginners"
To my dismay, after following the tutorial a couple of times, it ends with
the presenters app functioning correctly while mine does not. The issue is
that when we execute the following code to save changes to the database,
then close the app and restart, my changes are not saved while his
apparently are.
------------------------------------------------
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click

'need to get any changes that were made to the bindings source and place in
dataset

Me.BindingSourc e1.EndEdit() 'propagates changes made to data on form to
dataset

Dim rowsaffected As Integer = 0

rowsaffected = CustomerTableAd apter1.Update(M yCompanyDataSet 1.Customer)
'updates database and returns number of rows updated

MessageBox.Show (rowsaffected.T oString)

End Sub

-------------------------------------------

The author of the tutorial was working with Beta 2 so I'm not sure if there
is something missing in the tutorial or perhaps someting I missed twice
while following along.
Any tips on what may be missing are greatly appreciated.

-m

[Cor Ligthert [MVP]]

Mike,

Me.BindingSourc e1.EndEdit() 'propagates changes made to data on form to
dataset

Probably this has to be EndCurrentEdit because that propogates changes made
to data on a form to a dataset.

I hope this helps,

Cor

[Mike W]

Unfortunately, the EndCurrentEdit method does not exist in this context.
ms-help://MS.VSExpressCC. v80/MS.NETFramework .v20.en/cpref17/html/T_System_Window s_Forms_Binding Source_Members. htm
-m

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:el******** *****@TK2MSFTNG P09.phx.gbl...

Mike,

Me.BindingSourc e1.EndEdit() 'propagates changes made to data on form to
dataset

Probably this has to be EndCurrentEdit because that propogates changes
made to data on a form to a dataset.

I hope this helps,

Cor

[Cor Ligthert [MVP]]

Mike,

Unfortunately, the EndCurrentEdit method does not exist in this context.

That was why I wrote probably.

Normally we do it in this way.

BindingContext( ds.Tables(0)).E ndCurrentEdit()

Where ds.Table(0) represent your table or defaultview of that.

(There are in my opinion still many flaws in the documentation, there is
told that it is one of the major goals to get rid of those, so I am not sure
if this is one, however the EndEdit has never done what you told it should
do.).

http://msdn2.microsoft.com/en-us/lib...d.endedit.aspx

while this does it.

http://msdn2.microsoft.com/en-us/lib...rrentedit.aspx

Probably will this do it as well

BindingContext( directcast(Bind ingSource1,Data Table)).EndCurr entEdit
and if this gives an error than
BindingContext( directcast(Bind ingSource1,Data View)).EndCurre ntEdit

You tell than what object in the bindingsource is affected and do using the
bindingcontext an endcurrentedit on it.

All typed nothing tested so watch errors.

I hope this helps,

Cor