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?

Application object and its difference from cache object, What is an applica...

What is an application object & how it is different from c ache object? The Application object can be used in many situations where we want the data to be shared across user

Wrapper for ffmpeg, Help with making a wrapper in c# for ffmpeg to extract ...

Help with making a wrapper in c# for ffmpeg to extract audio from video

We''re seeking an it candidate, Project Description: We're seeking an IT...

Project Description: We're seeking an IT candidate with experience to help us optimizely,  Skills required: .NET, C# Programming, ASP, eCommerce, SQL

In which statement the linq query is executed, In which statement the LINQ ...

In which statement the LINQ query is executed? A LINQ query is executed in the For every statement in Visual Basic and in the for each statement in C#.

Capstone .., Why isn''t there an allowed amount for nonfacility for code 27...

Why isn''t there an allowed amount for nonfacility for code 27405?

Common code, How do I write common code for different dot net framework dat...

How do I write common code for different dot net framework data providers?

Package forwarding website design and develop, Project Description: We w...

Project Description: We want to prepare a package forwarding website. Package forwarding refers to a service where US forwarder provides International shoppers with a US address

Give benefits of asp.net web controls, Question: (a) Give four benefit...

Question: (a) Give four benefits of ASP.NET Web Controls. (b) List and explain any five properties of the ValidationSummary control. (c) Multiple Web Form controls ca

Manufacturing a erp website, Project Description: Looking for an interna...

Project Description: Looking for an internal-use, Manufacturing/ ERP Website developed for use at a Paper Mill. Modules/areas would include Customers, Scheduling, Sales Orders,

Develop a scrapebox software, Develop a scrapebox software Project Descr...

Develop a scrapebox software Project Description: I need a software name scrapebox Skills required are .NET, C Programming, Java, C# Programming, Software Architecture

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