Solved

Just starting out in VB.Net

Posted on 2008-06-12
4
220 Views
Last Modified: 2013-11-26
I am just switching from vb6 to vb.net.  I know, I'm way behind the curve.  I could really use some basic help on making a connection to an Access database and filling a form with a recordset.  VB.Net probably doesn't do it anything like VB6.

I will post my vb6 code to make clear what I am trying to achieve and would greatly appreciate the .net equivalent to the snippet.

Thanks in advance for any help
Public cn As New ADODB.Connection   

Dim strOpen as String

Dim rs As New ADODB.Recordset

 

strOpen = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDest

 

cn.Open strOpen 'open db connection object with connection string set above

 

 rs.Open "Select * from tbluser", cn, adOpenKeyset, adLockOptimistic

 Do While Not rs.EOF

    cboUserID.AddItem (rs.Fields("user_id") & ", " & rs.Fields("last_name") & ", " & rs.Fields("first_name"))

    rs.MoveNext

 Loop

 rs.Close

Open in new window

0
Comment
Question by:PSCTECH
  • 2
4 Comments
 

Author Comment

by:PSCTECH
ID: 21770281
.
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 21770481
Hi,

You can read this PAQ it has some examples how to handle SQL databases http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23349839.html

You just have to change the Sql to Oledb classes (ex. SqlConnection will be OleDbConnection)

Also you can look examples in MSDN:
http://msdn.microsoft.com/en-us/library/system.data.oledb(VS.80).aspx
0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 21773913
0
 

Author Closing Comment

by:PSCTECH
ID: 31466585
Thanks for the information, I really appreciate it
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now