To insert/update an advertisement for a product selected from the list,
the user can enter the value of Advertisement text.
To select an image for the advertisement, the user can click on 'Browse'
button. A file dialog is displayed as shown in figure 1.3.
The selected image appears in the 'New Ad Image' picture box as shown
in figure 1.4 . The user can commit
the changes by clicking the 'Save' button.
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)
1. Ensure that the Database setup
has been completed.
2. Open DSwithLOB.sln using Visual Studio .NET from <your-directory-structure>\DSwithLOB\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 DSwithLOB 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 DSwithLOB 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.
Directory |
File Name |
Description |
DSwithLOB\doc |
Readme.html |
This file |
blaf.css |
This is a cascading stylesheet applied to Readme.html |
DSwithLOB\doc\images |
This folder contains images used in the Readme.html file |
DSwithLOB\src |
DSwithLOB.sln |
Microsoft Visual Studio Solution |
|
DSwithLOB.suo |
Solution User option (this file gets automatically
generated when a Visual Studio Solution is created) |
DSwithLOB\src\ |
ConnectionParams.cs |
This C# file contains parameters for database connection |
|
ManipulateAds.cs |
This C# file contains source code for UI for sample
application and its functionality |
DSwithLOB.csproj |
C# project file |
DSwithLOB.csproj.user |
Visual Studio Project User Options (this file gets automatically
generated when a Visual Studio Project is created) |
ManipulateAds.resx |
.NET XML Resource Template (this file gets automatically generated
when a Visual Studio Project is created) |
DSwithLOB\setup |
DatabaseSetup.sql |
This is a SQL script file |