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?

Costing, how much guys cost for small 5 pages website designing in .net?

how much guys cost for small 5 pages website designing in .net?

Railway reservation system, i want to know the code for adding new item but...

i want to know the code for adding new item button in .net forms and delete button in vb.net forms. can any one pls help

Code for the file dependency in cache, Show the code for the file dependenc...

Show the code for the file dependency in cache? Partial Class Default_aspx Public Sub displayAnnouncement() Dim announcement As String If Cache("announcement") Is Noth

Checking for validity of an expression - c# program, Checking for validity ...

Checking for validity of an expression - C# Program Hello can you please provide me some examples regarding to the Checking for validity of an   expression in C#.

Need a excel assistant, Excel Assistant Need somebody to duplicate/creat...

Excel Assistant Need somebody to duplicate/create an excel spreadsheet and to make it website friendly. Desired Skills are VB.NET, VBA, C++, macros, webdesign

Validations, If one of your validations is complicated and does not fit i...

If one of your validations is complicated and does not fit in any validators, what you do? The best way is to go for CustomValidators. The sample code for a custom validator

Develop a windows desktop application, Develop a windows desktop applicatio...

Develop a windows desktop application Project Description: I am looking to get a desktop application developed. The desktop application will have the subsequent few features:

Explain the concept of bookmarks in wf 4.0, Explain the concept of Bookmark...

Explain the concept of Bookmarks in WF 4.0. In WF 4.0, a bookmark is a mechanism that enables an activity to wait for an input without interrupting a workflow thread. When an a

Udp based data transfer client-server in .net, UDP Based, Data Transfer Ser...

UDP Based, Data Transfer Server/ Client in .NET C# Project Description: We require the Network Level Functionalities (NLFs) of a Server/ Client for transferring data among tw

CSS, Howto create a simple stylesheet for a web application

Howto create a simple stylesheet for a web application

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