readme.html

从vc连接到oracle数据库。包括连接

<td>C++ header file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>17</td>

<td>font.cpp</td>

<td>C++ source file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>18</td>

<td>picture.h</td>

<td>C++ header file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>19</td>

<td>picture.cpp</td>

<td>C++ source file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>20</td>

<td>rowcursor.h</td>

<td>C++ header file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>21</td>

<td>rowcursor.cpp</td>

<td>C++ source file</td>

<td>Used by MSFlexgrid control class.</td>
</tr>

<tr>
<td>22</td>

<td>ConnectionParams.h</td>

<td>C++ header file</td>

<td>This file contains connection parameters to connect to particular database.&nbsp;</td>
</tr>

<tr>
<td>23</td>

<td>OraOLEDB.h</td>

<td>C++ header file</td>

<td>Include file for Oracle Provider for OLEDB</td>
</tr>

<tr>
<td>24</td>

<td>StdAfx.h</td>

<td>C++ header file</td>

<td>This&nbsp; includes standard system include files,or project specific
include files that are used frequently, but&nbsp;&nbsp; are changed infrequently</td>
</tr>

<tr>
<td>25</td>

<td>StdAfx.cpp</td>

<td>C++ source file</td>

<td>This is source file that contains the standard includes</td>
</tr>

<tr>
<td>26</td>

<td>StoredProcedure.sql</td>

<td>SQL script file</td>

<td>This file contains the sql script to create the stored&nbsp; packages,
stored procedures and synonyms required by the&nbsp; sample.</td>
</tr>

<tr>
<td>27</td>

<td>res/OleMR.rc2</td>

<td>Resource script file</td>

<td>Resource file</td>
</tr>

<tr>
<td>28</td>

<td>res/OleMR.ico</td>

<td>Image file</td>

<td>Icon file</td>
</tr>

<tr>
<td>29</td>

<td>OleMR.dsp</td>

<td>&nbsp;Project file</td>

<td>VC++ Project file</td>
</tr>

<tr>
<td>30</td>

<td>OleMR.dsw</td>

<td>Workspace file</td>

<td>VC++ workspace file</td>
</tr>

<tr>
<td>31</td>

<td>OleMR.clw</td>

<td>CLW file</td>

<td>Contains the class wizard information for the project</td>
</tr>

<tr>
<td>32</td>

<td>imageQ71.jpg</td>

<td>Image file</td>

<td>Used by ReadMe.html</td>
</tr>

<tr>
<td>33</td>

<td>imageUV5.jpg</td>

<td>Image file</td>

<td>Used by ReadMe.html</td>
</tr>

<tr>
<td>34</td>

<td>imageFTS.jpg</td>

<td>Image file</td>

<td>Used by ReadMe.html</td>
</tr>
</table>

<br>&nbsp;
<h2>
&nbsp;<a NAME="5. Prepare and Run the Sample"></a><font face="Arial,Helvetica"><font color="#000099">Prepare
and Run the Sample</font></font></h2>
<font face="Arial,Helvetica"><font color="#000099">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font></font>1. Extract the Sample files. Unzip VCOLEMRecordsSample.zip
using Winzip&nbsp; or command utility.
<p><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2.&nbsp; Connect to Oracle Sql*plus using &lt;username>/&lt;password>@&lt;connectstring>
.</font>
<br><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Here &lt;username> refers to the user in which all the tables have been
created and &lt;password> refers to the password given for the above user</font>
<br><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;connectstring> refers to the&nbsp; hostname.</font>
<p><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3.&nbsp; Make sure you have created the database tables required by this
sample. Refer db8setup.html for more information about setting up the</font>
<br><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
database tables and populating data.</font>
<p><font color="#000000"><font face="Arial,Helvetica">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4.</font>&nbsp; Create Database Stored Procedure by running StoredProcedure.sql
script.</font>
<br><font color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SQL> @&lt;path>StoredProcedure.sql</font>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.&nbsp; Open OleMR.dsw
using VC++ 6.0.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.&nbsp; Edit ConnectionParams.h&nbsp;
file to change the database connection parameters i.e. database name, user
name and password&nbsp; to database you
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
want to use.&nbsp; Save the file.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.&nbsp; Build and
Run the sample.
<br>&nbsp;
<h3>
&nbsp;<a NAME="Steps followed in the sample"></a><font face="Arial,Helvetica"><font color="#000099">Steps
in the sample</font></font></h3>

<p><br><font face="Arial,Helvetica"><font color="#000099">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
1.&nbsp;&nbsp; </font></font>The user has two options as shown in fig 1:
<center>
<p><img SRC="imageU5V.JPG" height=316 width=374></center>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
fig 1
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a. View Product Information
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This part shows
the feature of returning multiple recordsets and setting 'PLSQLRSet' property
through command object.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; It shows the
output in two categories, one for&nbsp; 'Orderable' products&nbsp;&nbsp;
and other for 'Under Development' products.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The output screen
is as shown in fig 2.
<center>
<p><img SRC="imageFTS.JPG" height=418 width=571></center>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
fig 2
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b.&nbsp;&nbsp; Insert Product Details.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
The option 'Insert Product Description' is to be selected in fig 1.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Following screen is displayed
<br>&nbsp;
<br>&nbsp;
<br>
<center>
<p><img SRC="imageQ71.JPG" height=476 width=468></center>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
fig 3
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Here
the user can insert product&nbsp; name and description in different languages.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
The user selects product from the first combo box&nbsp; and the language
in second combo box.
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
The existing name and&nbsp; description are retrieved from database and
shown in text boxes. The user can update the product information .
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
If the data does not exists, it gets inserted in the database.
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When
user clicks 慜K