Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update the Dataset
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01233541
Message ID:
01233891
Views:
12
Gregorio,

I used to have a lot of trouble with the BindingContext...EndCurrentEdit() in 1.1. It simply did not work correctly and I had to find ways to code around it. In 2.0, it seems it's still not fixed. However, there's the new BindingSource, perhaps it's .EndCurrentEdit() works better (I havent't really tested to see if it works, because I haven't gone back and refactored all my old work-arounds). Have you tried that instead?

~~Bonnie



>Mike:
>
>I used , but unfurtunelly Everytime I move my control did not update the record.
>
>Me.Dept_PkTxt.BindingContext(depts_changes, depts_changes.Table.Columns(1).ToString).EndCurrentEdit()
> Me.Dept_nameTXT.BindingContext(depts_changes, depts_changes.Table.Columns(3).ToString).EndCurrentEdit()
> Me.Dept_AbbTxt.BindingContext(depts_changes, depts_changes.Table.Columns(2).ToString).EndCurrentEdit()
>
>
>The code that create the binding is here,
>
>Public Sub New(ByVal parentdataset As DataSet)
> Depts_changes_final = parentdataset
>
> ' This call is required by the Windows Form Designer.
> InitializeComponent()
> depts_changes.Table = parentdataset.Tables(0)
>
>
> depts_changes.RowFilter = "Lsele = True"
> depts_changes.AllowEdit = True
>
> rposition = CType(Me.BindingContext(depts_changes), CurrencyManager)
> Dim depts_DB As New BindingSource
>
> depts_DB.DataSource = depts_changes
> Me.Dept_selection_BNav.BindingSource = depts_DB
> Me.Dept_PkTxt.DataBindings.Add("Text", depts_changes, depts_changes.Table.Columns(1).ToString)
> Me.Dept_nameTXT.DataBindings.Add("Text", depts_changes, depts_changes.Table.Columns(3).ToString)
> Me.Dept_AbbTxt.DataBindings.Add("Text", depts_changes, depts_changes.Table.Columns(2).ToString)
> depts_changes.AllowEdit = True
>
> ' Add any initialization after the InitializeComponent() call.
> End Sub
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform