Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET 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 July 19th, 2007, 11:34 PM
Registered User
 
Join Date: Jul 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default saving a dataset into access db

how can i save a dataset into my opened mdb?

my problem is when i use update it's only does it for the current session , but i want it to be permenant and written into the mdb file

so, how can i do it?
thanks
 
Old July 20th, 2007, 07:18 AM
Registered User
 
Join Date: Apr 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What do you mean by " it's only does it for the current session"?

Jim
 
Old July 20th, 2007, 09:13 AM
Registered User
 
Join Date: Jul 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i meant that if i change some thing it saves it until i exit the application and if i open it again that i don't the things that i have changed

by the way , i did it with the rad tools
not in code

but when i use the update method it only works until i exit
 
Old July 21st, 2007, 05:28 AM
Registered User
 
Join Date: Jul 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

nevermind i solved it myself

i found out that it didn't save the changes on the mdb because the mdb was set to copy always

so, i set it to copy if newer , and now it works!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving DataSet data on client machine in .csv file balesh ASP.NET 1.0 and 1.1 Professional 0 October 25th, 2006 06:17 AM
Dataset merging and saving to database Talarin3 ADO.NET 8 April 19th, 2006 11:30 AM
update access db with dataset DennisGi ASP.NET 1.0 and 1.1 Basics 0 November 8th, 2004 04:43 AM
Saving a dataset to an Access table smego ADO.NET 0 June 2nd, 2004 01:19 AM
Re: SQL Server dataset to ACCESS dataset dazzer ADO.NET 0 March 22nd, 2004 05:28 AM





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