!C99Shell v. 1.0 pre-release build #13!

Software: Apache. PHP/5.5.15 

uname -a: Windows NT SVR-DMZ 6.1 build 7600 (Windows Server 2008 R2 Enterprise Edition) i586 

SYSTEM 

Safe-mode: OFF (not secure)

E:\oracle\product\10.2.0\client_2\oledb\samples\DataSet\DMLOperOnDS\doc\   drwxrwxrwx
Free 4.94 GB of 239.26 GB (2.06%)
Detected drives: [ a ] [ c ] [ d ] [ e ] [ f ]
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    


Viewing file:     Readme.html (13.78 KB)      -rw-rw-rw-
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
OLEDB - DML Operations On DataSet- Readme

Manipulate Products - DML Operations on DataSet Through Oracle Provider for OLEDB

Table of Contents

Overview of the Sample Application 
Back To Top
This .NET sample application aims at demonstrating Data Manipulation Language (DML) operations on 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. OleDbCommand represents SQL statements to execute against datasource. 

 When this sample is run, a list of existing products from database appears in a tabular format. The user can change product details by overwriting existing value. To insert new product details the user can navigate to the end of the table and enter new product details. To 'Commit' changes the user can click 'Save' button. The 'Update' method of the OleDbDataAdapter is called to resolve changes from Dataset back to the data source, therefore commiting the changes. Hence it demonstrates DML operations on a Dataset. 

 

User Notes with Screen Shots
Back To Top

When this sample application is run, a list of Products from database is displayed as shown in figure 1.2, 
The user can add new products by appending new data in the datagrid displayed, also the user can update the existing 
data for products by overwriting the existing values. To commit changes the user can click the 'Save' button. 
On clicking the 'Close' button, the application gets closed. 

                                            Figure 1.2 Screen shot for Manipulate Products Sample 

Required Software 
Back To Top
1. Visual C# installed with MS Development Environment 7.0 version (MS Visual Studio .NET)  including MS .NET Framework 1.0 version

2. Oracle8i Database or later running SQL*Net TCP/IP listener (can be downloaded here )

3. Oracle Provider for OLE DB (can be downloaded here)

Extracting the Sample
Back To Top
Unzip DMLOperOnDS.zip using Winzip or command utility to your convenient directory. Extraction of the zip file results 
in the creation of 'DMLOperOnDS' directory. 

Database Setup 
Back To Top
Connect to your database as any user and run the script DMLOperOnDS\Config\DatabaseSetup.sql at the 
SQL prompt
SQL> @<your directory structure>\DMLOperOnDS\Config\DatabaseSetup.sql

This creates a user "OraNet" with password "OraNet". All the database objects required by the application
are created and populated with initial data.

Following is the list of database objects that get created by running DatabaseSetup.sql file. 
Object Name Description
Products Table that store information about products.
Printmedia Table that stores information about the advertisement related to products.
Prodid_seq Sequence for auto generating Product IDs.
Adid_seq Sequence for auto generating Advertisement ID.
Populate_AdID Trigger for populating  Ad_ID column of 'PrintMedia'  table on insertion.
PopulateProduct_ID Trigger for populating value of Product_ ID field from Adid_seq sequence, on insertion. 

Preparing and Running the Sample
Back To Top
1. Ensure that the Database setup has been completed. 

2. Open DMLOperOnDS.sln using Visual Studio .NET from <your-directory-structure>\DMLOperOnDS\src folder. 

3. Edit ConnectionParams.cs file to change the database connection parameters i.e.TNSName for  database
you want to use . Save this file. 

4. Ensure that the following .NET Component References have been added to DMLOperOnDS project: 
          System, 
          System.Data, 
          System.Drawing, 
          System.Windows.Forms, 
          System.XML. 

To add the above .NET Components 
a)Go to Menu ->View-> Solution Explorer. 
b)Right click on DMLOperOnDS project, choose 'Add Reference'. 
c)Choose the above .NET Components from the list displayed. 
d)Click 'Select', then OK. 
e) The chosen .NET component gets added to the project. 
5. Build and run the sample. 

Description of Sample Files 
Back To Top
Directory File Name Description
DMLOperOnDS\doc Readme.html This file
blaf.css This is a cascading stylesheet applied to Readme.html
DMLOperOnDS\doc\images This folder contains images used in the Readme.html file
DMLOperOnDS\src DMLOperOnDS.sln Visual Studio Solution
  DMLOperOnDS.suo Solution User option (this file gets automatically generated when a Visual Studio Solution is created).
DMLOperOnDS\src\DMLOperOnDS\ ConnectionParams.cs This C# file contains parameters for database connection
ManipulateProducts.cs This C# file contains source code for UI for sample application and its functionality
DMLOperOnDS.csproj C# project file
DMLOperOnDS.csproj.user Visual Studio Project User Options (this file gets automatically generated when a Visual Studio Project is created)
ManipulateProducts.resx .NET XML Resource Template (this file gets automatically generated when a Visual Studio Project is created)
DMLOperOnDS\setup DatabaseSetup.sql This is a SQL script file 

Please enter your comments about this sample in the OTN Sample Code Discussion Forum.

:: Command execute ::

Enter:
 
Select:
 

:: Search ::
  - regexp 
:: Upload ::
 
[ ok ]

:: Make Dir ::
 
[ ok ]
:: Make File ::
 
[ ok ]

:: Go Dir ::
 
:: Go File ::
 

--[ c99shell v. 1.0 pre-release build #13 powered by Captain Crunch Security Team | http://ccteam.ru | Generation time: 0.0312 ]--