944,104 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 1869
  • VB.NET RSS
Nov 3rd, 2009
0

VB 2008 & Database Issues

Expand Post »
Hello everyone!

So as my first post, I would like to say I am in no way unfamiliar with Visual Basic or programming in general, but this Database integration is giving me quite a problem! lol

So basically I have a VB 2008 Project with a single form that displays a list of guitars that I have in a SQL Database. I made the Database inside of VB with the "Add Data Connection" option. It should also be known I know very little about SQL in general. The information in the columns is placed in its own text box to be displayed.

My problem is I can not figure out how to "Add" or "Delete" Records to/from my Database.

My original plan was to have the Binding Source Navigator work all these functions for me. The Add worked fine (as long as you did not leave any necessary boxes blank), and Delete worked to an extent. I added a simple "Double Check" box that asked if they are sure they wanted to delete the entry. But no matter your answer, it deleted it anyways. So I decided it would be easier to just move the Add and Delete functions to command buttons.

Problem there is, I have no clue on how to even start. And all my "Googling" can not provide me with an adequate answer.

I will be happy to get some Code and Pics of the project to simply what I am saying as soon as my VMWare Fusion is updated and working.

Oh Im a Mac user, did I mention that? haha

Thanks in advance everyone!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
JonnyHawes is offline Offline
2 posts
since Nov 2009
Nov 4th, 2009
0
Re: VB 2008 & Database Issues
check out these train videos.
http://msdn.microsoft.com/en-us/vbas...rmsoverdata_08

Beth is explaining very well how to do that
Featured Poster
Reputation Points: 208
Solved Threads: 168
Practically a Master Poster
GeekByChoiCe is offline Offline
692 posts
since Jun 2009
Nov 4th, 2009
0
Re: VB 2008 & Database Issues
for some reason it did a double post. sry
Last edited by GeekByChoiCe; Nov 4th, 2009 at 4:04 am.
Featured Poster
Reputation Points: 208
Solved Threads: 168
Practically a Master Poster
GeekByChoiCe is offline Offline
692 posts
since Jun 2009
Nov 8th, 2009
0
Re: VB 2008 & Database Issues
Thank you very much sir. She helped me work out my Delete function in about 10 minutes. I am still struggling with my Add function but I have not had a whole lot of time to sit down and really play with it all yet since I watched a few of those vids.

I appreciate your quick response, and useful to boot! haha
Reputation Points: 10
Solved Threads: 0
Newbie Poster
JonnyHawes is offline Offline
2 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: Salary Review project
Next Thread in VB.NET Forum Timeline: Save And retrieve Picture in Access Database In Vb.net





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC