How Can We Connect To Microsoft Access, Foxpro, And Oracle Etc?

1.	How Can We Connect To Microsoft Access, Foxpro, And Oracle Etc?
Answer» Microsoft provides System.Data.OleDb namespace to communicate with databases like success , Oracle etc. In SHORT, any OLE DB-Compliant database can be connected using 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 The main heart is the “LOAD data ()” method which actually loads the data in list box. Microsoft provides System.Data.OleDb namespace to communicate with databases like success , Oracle etc. In short, any OLE DB-Compliant database can be connected using System.Data.OldDb namespace. The main heart is the “Load data ()” method which actually loads the data in list box.

Answer»

Microsoft provides System.Data.OleDb namespace to communicate with databases like success , Oracle etc. In SHORT, any OLE DB-Compliant database can be connected using 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

The main heart is the “LOAD data ()” method which actually loads the data in list box.

Microsoft provides System.Data.OleDb namespace to communicate with databases like success , Oracle etc. In short, any OLE DB-Compliant database can be connected using System.Data.OldDb namespace.

The main heart is the “Load data ()” method which actually loads the data in list box.

How Can We Connect To Microsoft Access, Foxpro, And Oracle Etc?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment