How to connect to microsoft access, foxpro , oracle etc?, DOT NET Programming

Assignment Help:

How can we connect to Microsoft Access, Foxpro , Oracle etc ?

The Microsoft provides System.Data.OleDb namespace to communicate with the databases such as Oracle, scess  etc. In brief any OLE DB-Compliant database can be connected using the System.Data.OldDb namespace.

Private Sub loadData()

Dim strPath As String

strPath = AppDomain.CurrentDomain.BaseDirectory

Dim objOLEDBCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & strPath & "Nwind.mdb")

Dim objOLEDBCommand As OleDbCommand Dim objOLEDBReader As OleDbDataReader Try

objOLEDBCommand = New OleDbCommand("Select FirstName from Employees")

objOLEDBCon.Open() objOLEDBCommand.Connection = objOLEDBCon objOLEDBReader = objOLEDBCommand.ExecuteReader() Do While objOLEDBReader.Read()

lstNorthwinds.Items.Add(objOLEDBReader.GetString(0)) Loop

Catch ex As Exception

Throw ex

Finally objOLEDBCon.Close()

End Try

End Sub


Related Discussions:- How to connect to microsoft access, foxpro , oracle etc?

Print floyd''s triangle - c# program, Print Floyd's Triangle - C# Program ...

Print Floyd's Triangle - C# Program I am unable to make out how to print Floyd's Triangle in C# language. Can anyone suggest me any example for this.

I need a windows sharepoint services or similar solution, I need a Windows ...

I need a Windows SharePoint Services or Similar Solution My company desires a reliable way of managing the documents online for each of its clients. The solution would want t

Difference between shadowing and overriding, What is the difference between...

What is the difference between Shadowing and Overriding? The main basic difference between shadowing and overriding are as follows:- 1) The Overriding redefines only the imp

SMS APPLICATION WITH AUTO REPLY, I want to develop SMS application with aut...

I want to develop SMS application with auto reply based on the content of the message using gsm modem. eg.Student results checking using cell phone via sms. How do i do this?

List the session variables names and values, Question: (a) One of the ...

Question: (a) One of the advantages of the Session object is that it prompts to you when a user session begins. In this context, a user fills in a registration form and the Se

Develope a microblogging and bookmarking site, General Overview A number...

General Overview A number of organisations are using micro-blogging as a cost-effective way of communicating with customers, building online communities and releasing informatio

I need automatic rate processing, Project Description: PURPOSE Xconne...

Project Description: PURPOSE Xconnect needs a fully automated system for receiving and processing Terminator cost sheets based on set business principle, convert the accepted

Types of diagrams in uml, How many types of diagrams are there in UML? ...

How many types of diagrams are there in UML? There are nine types of diagrams in the UML as shown below:- 1)Use case diagram: The use case diagram describe "WHAT" of a

Crystal Report base output, Hello, I want to develop one crystal report. I ...

Hello, I want to develop one crystal report. I have one database which has 5 field.One is string and others are Boolean. String field name is State and Four remaining fields are Th

Develop a iphone and android mobile game, Develop a iPhone and Android mobi...

Develop a iPhone and Android mobile game Project Description: I am seeking a developer to create a mobile game for me. I need an endless runner game with simple controls. The

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd