473,573 Members | 2,719 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB.NET and Data Adapter Update Method Not "Updating"

5 New Member
I have a VB .NET application that is communicating properly with an Access DB. I have a slew of textbox controls bound to a dataset and when the application launches, the fields are correctly populated.

If someone changes a value in one of the text boxes, I need to have a button capture the change and commit the update to Access. I know I'm close, but something is missing. I have a data adapter called:
OleDbDataAdapte r1

and a dataset called:
DsMyMonthlyInco me1

My button function is:
Try
OleDbDataAdapte r1.Update(DsMyM onthlyIncome1)

Catch ex As Exception
MsgBox(ex.ToStr ing)
End Try

No error occurs, but the changed information in the text field never gets communicated to the Access DB. Have I not captured the changes by having the textbox controls bound?

I've searched quite a bit today, and not found the information I seek. I am lost here and appreciate the help.
Jan 10 '07 #1
6 7012
pooba53
5 New Member
Anybody help me here?
Jan 11 '07 #2
pooba53
5 New Member
Anybody help me here?

Anyone at all...
Jan 12 '07 #3
pooba53
5 New Member
Anyone at all...
Seriously, no waiting :-)
Jan 13 '07 #4
yorkshire2510
1 New Member
pooba,

Does the updates involve updating several tables within the database? If so, then you need to update the tables one at a time, by adding the name of the table to the update parameters:

OleDbDataAdapte r1.Update(DsMyM onthlyIncome1, "tableName" )

I hope this helps
Jan 18 '07 #5
gerrymad
1 New Member
This messed me up for quite a while. Basically VB creates a temp file at run time when in the developer mode. There is a good explanation at this URL:
https://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
Jan 31 '07 #6
pooba53
5 New Member
All I needed to do is something like this before doing the update:

Dim cm As CurrencyManager
cm = DirectCast(Bind ingContext(DsMy MonthlyIncome1, "Budget Items"), CurrencyManager )
cm.EndCurrentEd it()

-Dan

This messed me up for quite a while. Basically VB creates a temp file at run time when in the developer mode. There is a good explanation at this URL:
https://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
Jan 31 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

53
3631
by: Oliver Fromme | last post by:
Hi, I'm trying to write a Python function that parses an expression and builds a function tree from it (recursively). During parsing, lambda functions for the the terms and sub-expressions are constructed on the fly. Now my problem is lazy evaluation. Or at least I think it is. :-)
1
14936
by: arvee | last post by:
Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred in system.data.dll Additional information: Parameter 'p1': No size set for variable length data type: String. The column is nullable and of type varchar2(50). I'm aware that I can store DBNull.Value...
0
4994
by: saraDotNet | last post by:
hi everybody , I'm a beginner student in vb.net,and I'm working on a very small project as a homework,and I've some questions which I ought to search for their solutions via any source . My question, I need to make an (Update )button in most of my VB forms,which enable me to update any row elements in the datasource in Access through each form...
1
1966
by: Robert Hooker | last post by:
Hi All, After moving to VS2005, we've noticed that opening an existing (large) solution and being able to type code takes a lot longer than in VS2003. Typically, the IDE will open, and all the windows will appear, but then the hour glass will flick on and off for about 1 minute. If the "Pending Checkins" window is open, I can see a message...
6
2643
by: =?Utf-8?B?S2Fp?= | last post by:
Hi all, using AJAX Toolkit with vb.net 2.0 how could I make this "Updating..." Screen like e.g. on Codeplex when you click on the "Vote" button http://www.codeplex.com/AtlasControlToolkit/WorkItem/View.aspx?WorkItemId=9124 ? So the whole screen becomes inactive and a small window says "Updating..." so the user knows that something is going...
2
1953
by: Mike Gleason jr Couturier | last post by:
In VS Studio 2008, when I'm opening the "Pending Checkins" tab, the content is stuck with "Updating..." and never shows the checked-out files... Any ideas!? I'm doing my check-ins directly in sourcesafe. Every other ss commands are working in VS Studio 2K8 Thanks
2
3266
by: bednarz.thomas | last post by:
I have the following business Object(s): public class ParentObject { public ParentObject(string somestring) { ...- } ....
0
7750
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7674
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8182
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7744
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8039
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5559
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3708
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2170
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.