Using Oracle Developer Tools with Visual Studio - Reviewing the Connection Properties
(Page 3 of 5 )
Connection is one of the most important properties. Some of the connection properties for the Oracle 10G XE database will be explored using a Windows form. A Windows Application is created with the name GetXeData as shown for this purpose.
Onto Form1, drag and drop the COUNTRIES table after highlighting it in the Oracle Explorer. This will not add anything visible to the form, but it adds the countriesOracledataAdpter1 icon to the tray below the form as shown.
After adding the above data adapter a window comes up with a message as shown.
If you accept and click the Yes button, the countriesOracleConnection1 icon will also be added. Now the form has enough data related information.
Add a number of textboxes, an equal number of labels and a command button as shown. You may format the form suitably.
Click open Button1 which will take you to the code behind the form as shown. Add the imports Oracle.DataAccess.Client statement at the top of this page as shown. To the click begin to add the code shown. You will get drop-down help to choose properties and methods as shown.
You can see that the imports statement has added a number of objects related to the countries table. You can not only select, but you can also manipulate data in the server using code. This tutorial will only show how the data is displayed.
Next: The Code Behind Form1 >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
/ 7 
