How can we connect to Microsoft Access , Foxpro , Oracle etc
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
Microsoft provides System.Data.OleDb namespace to communicate with databases like
scess , Oracle etc. In short any OLE DB-Compliant database can be connected using
Note :- Small sample of OLEDB is provided in WindowsAppOleDb which uses Nwind.mdb in bin directory to display data in Listbox.
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 Loaddata() method which actually loads the data in listbox.
Note:- This source code has the connectionstring hard coded in the program itself which is not a good programming practice. For windows application the best place to store connectionstring is App.config. Also note that AppDomain.CurrentDomain.BaseDirectory function gives the current path of the running exe which is BIN and the MDB file is in that directory. Also note that the final block which executes irrespective that there is error or not. Thus ensuring that all the connection to the datastore is freed. Its best practice to put all clean up statements in finally block thus ensuring that the resources are deallocated properly.
2007-10-24, 5771👍, 0💬
Where Do You Download JUnit? Where do I download JUnit? I don't think anyone will ask this question ...
.NET INTERVIEW QUESTIONS - Where do you specify session state mode in ASP.NET ? The following code e...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But th...
Can you prevent a class from overriding ? If you define a class as Sealed in C# and NotInheritab...
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQ...