Wrox Programmer Forums
|
BOOK: Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer
This is the forum to discuss the Wrox book Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer by Rod Stephens; ISBN: 9780470596906
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 13th, 2012, 11:47 AM
Authorized User
 
Join Date: Jan 2012
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 35-36

For Lesson 35-36, we work with forms and databases.

How do I get the program to save this information to a specified location??

Also, if I don't specify a location or not make a function for it, do the data just stay in the temporary memory??

Thanks.
 
Old September 13th, 2012, 01:45 PM
Rod Stephens's Avatar
Wrox Author
 
Join Date: Jan 2006
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default

The database is separate from the program. Depending on the kind of database you are using, it may be in a file (as in an Access database or Excel workbook) or in some sort of logical database server (as in SQL Server, SQL Server Express, or MySQL). That's where the data is stored. You need to use some database product to create the database before you can use it with your program.

For example, suppose a program connects to a SQL Server database and adds some records. Later another program can connect to the same SQL Server database and find the data there.

If a program is using DataSets to store and manipulate information, it must use two methods to load and save the data: Fill and Update. Fill copies data from the database into the DataSet. Update copies any changes back into the database.

A fairly common mistake is to use Fill to load the data but then forget to call Update to save it. You make changes to the data and close the program but the changes are never saved.

I hope that helps. Let me know if that didn't clear things up.
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Lesson 35 - Scripts aren't Working on my server ZanderFly BOOK: JavaScript 24-Hour Trainer 4 March 15th, 2012 05:32 PM
Problem with Lesson 36, Help needed alawode BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer 0 February 16th, 2012 10:37 PM
Lesson 35 jlbrown BOOK: Microsoft Access 2010 24-Hour Trainer 4 February 4th, 2012 08:13 PM
Lesson 36 Tryit Mark P. BOOK: Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer 4 October 11th, 2011 02:49 PM
Page 35 Errata LongJohnSilver BOOK: Professional Visual Basic 2008 ISBN: 978-0-470-19136-1 2 January 9th, 2009 09:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.