Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How can we connect to Microsoft Access , Foxpro , Oracle etc
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
✍: Guest
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
System.Data.OldDb namespace.
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, 7002👍, 0💬
Popular Posts:
Which bit wise operator is suitable for checking whether a particular bit is on or off? The bitwise ...
How is normally a project management plan document organized ? PMP document forms the bible of a pro...
What does a well-written Object Oriented program look like? A well-written object oriented program e...
How To Write a Minimum Atom 1.0 Feed File? - RSS FAQs - Atom Feed Introduction and File Generation I...
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is...