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
Site minder Authentication in SharePoint We have fit site minder agent in SharePoint 2010. We would like to have incorporate with site minder agent. Currently site-minder age

how socket workes in .net

How can we identify that the Page is PostBack? The Page object has the "IsPostBack" property which can be checked to know that the page is posted back.

i want to know how can i sum quantity column in gridview and place it in first row...not in footer..in .net. Rply ASAP

Training and placement cell Project Description: It is about placement and training cell of any college. I have made this for one college. If needed, i can modify it. Student

Asp .net Facebook app project completion Project Description: We are a small development house in Singapore, and have a project which is 90 percent complete; thus our previou

What is Delegation? A delegate seems like a strongly type function pointer. Delegates can request the methods that they reference without making explicit calls to those methods

Develop a Earnings Calculator for my Paid to Click Website Project Description: I want a calculator which will show my members how much they could earn, with value per click,

How can we load multiple tables in a DataSet ? objCommand.CommandText = "Table1" objDataAdapter.Fill(objDataSet, "Table1") objCommand.CommandText = "Table2"

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