VB.net Front-end Access Back-End Question

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jan 2007
Posts: 2
Reputation: Tim Riley is an unknown quantity at this point 
Solved Threads: 0
Tim Riley Tim Riley is offline Offline
Newbie Poster

VB.net Front-end Access Back-End Question

 
0
  #1
Jan 15th, 2007
I want to use an MS Access Database as a back-end.

I am trying to:
Use data in one field (column) of my Access database as the items in a listbox

Example, "Customer #" is a field in my database, i want to show all of the customer numbers in a dropdown.

I need help from the database connection, to displaying items in one field of my database in a listbox.

Is there anybody out there that knows how to do this??? Please help.

P.S. I am trying to somehow be able to input a customer number, and have my VB program display some other info about that record (other columns). if you have a suggestion overall of a better way to do this than a listbox I am open to suggestions.
Last edited by Tim Riley; Jan 15th, 2007 at 5:04 pm.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,249
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: VB.net Front-end Access Back-End Question

 
0
  #2
Jan 16th, 2007
in the "server explorer" tootlbar , right click to make a new conection and dataset and point it to your Access database - make sure you choose Jet as your data provider. Then you should just be able to set the comboiboxes datasource property to that table.
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC