This .NET sample application aims at demonstrating
how to populate a DataSet through Oracle Provider for OLE DB . The
Oracle9i Release 2 OLE DB provider introduces full support for .NET
via the Microsoft OLE DB .NET data provider. With OLE DB .NET, applications
can access the Oracle database from any .NET programming language.
OLEDB .NET Data Provider provides a collection of classes that are
used to access database. Figure 1.1, describes how the
data is accessed using OLEDB .NET Provider.
Figure
1.1 Data Access Using OLEDB .NET Provider
DataSet is a major component of ADO .NET. It is an in-memory cache of
the data retrieved from the database. OleDbDataAdapter represents a set
of data commands and a database connection that are used to fill the Dataset
based on the query given. OleDbCommand represents SQL statements to execute
against datasource. OleDBConnection is used to build the database connection.
This sample application is a Visual Basic .NET Application that
displays a product catalog for a product store. When this sample
is run, a list of products from database appears in a DataGrid (in
tabular format). The DataGrid gets populated from a DataSet which
is filled by a DataSource using OleDbDataAdapter. Hence demonstrating
how to populate DataSet through Oracle Provider for OLE DB.
|