473,385 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

update questions

In Access any changes to data is immediately saved in the tables. I am
learning about vb.net. I have a couple of applications that I want to build
that are not designed to be accessed by more than one person. As I am going
through the various reading material I have learned that vb.net creates a
local snapshot of the Access table, holds that information in memory, and
then the updates are done by clicking a button.

Questions
1. Is there any reason in vb.net why I wouldn't want the Access like
functionality in the described situation?
2. If the answer to #1 is no what is the best approach to achieving that
functionality?

Thank you for helping the beginner.

Fay
Nov 20 '05 #1
2 970
Fay Yocum wrote:
In Access any changes to data is immediately saved in the tables. I am
learning about vb.net. I have a couple of applications that I want to
build that are not designed to be accessed by more than one person.
As I am going through the various reading material I have learned
that vb.net creates a local snapshot of the Access table, holds that
information in memory, and then the updates are done by clicking a
button. ADO.NET ( Part of the framework ) works in a disconnected mode.
One you run the select statements the connector, dataAdaptor fills
the designated DataSet or Table, you work on it and then send it back
to Access using update.


Questions
1. Is there any reason in vb.net why I wouldn't want the Access like
functionality in the described situation? Not if your application demands it.
2. If the answer to #1 is no what is the best approach to achieving
that functionality? Once you have made your changes, simply call the DataAdapter.Update command

Regards - OHM#

Thank you for helping the beginner.

Fay


Regards - OHM# On**********@BTInternet.com
Nov 20 '05 #2
Fay Yocum wrote:
In Access any changes to data is immediately saved in the tables. I am
learning about vb.net. I have a couple of applications that I want to
build that are not designed to be accessed by more than one person.
As I am going through the various reading material I have learned
that vb.net creates a local snapshot of the Access table, holds that
information in memory, and then the updates are done by clicking a
button. ADO.NET ( Part of the framework ) works in a disconnected mode.
One you run the select statements the connector, dataAdaptor fills
the designated DataSet or Table, you work on it and then send it back
to Access using update.


Questions
1. Is there any reason in vb.net why I wouldn't want the Access like
functionality in the described situation? Not if your application demands it.
2. If the answer to #1 is no what is the best approach to achieving
that functionality? Once you have made your changes, simply call the DataAdapter.Update command

Regards - OHM#

Thank you for helping the beginner.

Fay


Regards - OHM# On**********@BTInternet.com
Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: kalamos | last post by:
This statement fails update ded_temp a set a.balance = (select sum(b.ln_amt) from ded_temp b where a.cust_no = b.cust_no and a.ded_type_cd = b.ded_type_cd and a.chk_no = b.chk_no group by...
27
by: VK | last post by:
<http://www.jibbering.com/faq/#FAQ3_2> The parts where update, replacement or add-on is needed are in <update> tag. 3.2 What online resources are available? Javascript FAQ sites, please...
4
by: The Spoon | last post by:
I am looking for functions that can be used to automatically update the system date and time on an NT based system, resulting from manually entered date and time values input by an operator via a...
4
by: Nick Barr | last post by:
Hi, I am trying to gather stats about how many times a resource in our web app is viewed, i.e. just a COUNT. There are potentially millions of resources within the system. I thought of two...
5
by: Stephen Plotnick | last post by:
I'm very new to VB.NET 2003 Here is what I have accomplished: MainSelectForm - Selects an item In a public class I pass a DataViewRow to ItemInformation1 Form ItemInformation2 Form
12
by: si_owen | last post by:
Hi all, I have a SQL query that worked fine in my project until it came to testing. I found that the NvarChar fields I have wont accept the use of an ' My code and query is here does anyone...
2
by: rn5a | last post by:
When a DataGrid is in the editable mode, users can change the quantity of the items that are currently in his shopping cart by entering a new quantity in a TextBox. After changing the quantity, a...
0
by: Cindy Huyser | last post by:
I have an Access 2000 database behind a threaded Java application that that can have have concurrent access to the same table (but not the same record). The database is set up for shared access...
2
by: sirdavethebrave | last post by:
Hi guys - I have written a form, and a stored procedure to update the said form. It really is as simple as that. A user can go into the form, update some fields and hit the update button to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...

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.