Submitted on: 1/1/2015 9:55:00 AM
By: Ravindrar(RMKT.Net) (from psc cd)  
Level: Beginner
User Rating: By 27 Users
Compatibility: VB.NET
Views: 2687
     Make a Simple Connection to an Access/SQL Server Database

				ADO.Net - The new data access model for the .Net framework(Microsoft).
ADO.Net is essentially a set of classes that allow a .Net Application to read and write data from and to a data source respectively.
To Create a Connection to an Access Data Base:
1. Imports System.Data
2. Create a connection object
Dim conAccess as new OLEDB.OLEDBConnection
ConAccess.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = C:\Program files\DataBase Name;"
3. ConAccess.Open() ' To Open the Connection
To Connect to SQL Server
1. Dim Consql as new sqlclient.sqlconnection()
2. ConSql.connectionstring = "Integrated Security = True;Data Source = LocalHost;Initial Catalog = Database Name;"
3. 'To Open the Connection

Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this article (in the Beginner category)?
(The article with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)

Other User Comments

 There are no comments on this submission.

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular article, please click here instead.)

To post feedback, first please login.