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

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

Posted Date: 9/24/2012 2:28:53 AM | Location : United States







Related Discussions:- How to connect to microsoft access, foxpro , oracle etc?, Assignment Help, Ask Question on How to connect to microsoft access, foxpro , oracle etc?, Get Answer, Expert's Help, How to connect to microsoft access, foxpro , oracle etc? Discussions

Write discussion on How to connect to microsoft access, foxpro , oracle etc?
Your posts are moderated
Related Questions
Avoid deadlock in threading The best  and careful planning may avoid deadlocks.There are so many ways Microsoft has provided by which you can decrease deadlocks for example Int


Project Description: The software is developed to help individuals train both their subconscious and conscious mind so they can improve their life and get more success. - How

I Need paypal and urolator pro api integrated in to aspx site Project Description: Need paypal and urolator pro api integrated in to aspx site. The is presently completed and

How do we assign page specific attributes? The Page attributes are specified by using the @Page directive.

What are the metrics followed in project management? The most metric sets deal with a variation of these attributes and are chosen to help the project managers gain insight int

What are wait handles? The Wait handles sends signals of a thread status from one thread to another thread. There are 3 kind of wait modes:- A)WaitOne. B)WaitAny. C)Wa

Among the items that are related to the implementation of an application for automation of processes, are shown as follows: a) The online patient registry through which patients

How many types of assemblies are there? Private, Public/Shared, Satellite. A private assembly is normally used by a one application, and is stored in the application's director

What is different overloading and overriding, please explain