Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics 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
  #11 (permalink)  
Old December 10th, 2005, 03:25 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 453
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via AIM to Ankur_Verma Send a message via MSN to Ankur_Verma
Default

You are welcome buddy. Do write back.

Ankur
  #12 (permalink)  
Old March 13th, 2006, 05:30 PM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So I think I've tracked down the root of the whole problem. When you add the access file as a data source to your project, Visual Studio asks you if you want to copy the database file into your project workspace. If you answer "yes" to this, VS gives you a fresh copy of the data base to work with every time you run the project. Your changes are being propagated back to the Access db, but it's saving to the copy in your bin directory. Since that DB gets overwritten every time, you can't see the changes unless you manually start the application yourself by clicking on the icon in the bin directory (as opposed to launching it from visual studio).
Since the book's example is with a SQL database, it doesn't mention the dialog that happens when you use a database file on the local machine.
  #13 (permalink)  
Old April 27th, 2006, 08:27 AM
Registered User
 
Join Date: Apr 2006
Location: League City, Texas, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to preston_jb
Default

Ankur,

I have the same problem, but I am not using Access, rather I am using SQL Server 2005 with the *.dbo extension.

I am hoping that maybe you can help me resolve my problem as well.

I am using Window 2000 Server w/Sp 4 and all the latest updates.

Thanks in advance for your response.

Preston_JB
  #14 (permalink)  
Old October 19th, 2006, 09:29 PM
Registered User
 
Join Date: Oct 2006
Location: Jakarta, DKI Jakarta, Indonesia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear Ankur, I'm facing the same problem like wb8bgy and preston_jb. Could you send me email of the sample code to my email address : roberts@apotik2000.net. I really frustated with this situation. Thanx in advance.

  #15 (permalink)  
Old October 24th, 2006, 03:14 AM
Authorized User
 
Join Date: Oct 2006
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to salemkoten
Default

Hi Ankur, I also have the sam prob, I use MSSQL2005 express. Please send the same code to my e-address: hoa0612@gmail.com
Thanks in advance.

  #16 (permalink)  
Old October 24th, 2006, 03:20 AM
Authorized User
 
Join Date: Oct 2006
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to salemkoten
Default

PS: I can update my databases by using sqlDataAdapter control, but using code failed.
Could you send me email?
Thanks.

  #17 (permalink)  
Old February 12th, 2008, 09:12 PM
Registered User
 
Join Date: Feb 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for this posting!! This saved me some development time and headache tonight.

  #18 (permalink)  
Old February 19th, 2008, 11:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 453
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via AIM to Ankur_Verma Send a message via MSN to Ankur_Verma
Default

Poem to my ears. Glad to know it was of use to you.

Regards
Ankur




Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning 2 BindingSources to a BindingNavigator Bjay Pro VB Databases 3 July 19th, 2007 07:17 AM
BindingNavigator Exception osorio.agustin Visual Basic 2005 Basics 0 March 13th, 2007 08:39 PM
bindingNavigator problem! angelran C# 2005 2 January 21st, 2007 05:57 AM
Bindingnavigator ldg_louie Visual Basic 2005 Basics 0 June 8th, 2006 07:02 PM
BindingNavigator Question lixin8111 Visual Basic 2005 Basics 0 May 25th, 2006 09:34 PM





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