How to Connect Visual Basic and Oracle
Steps to Connect Visual Basic & Oracle
A tutorial by B.BHUVANESWARAN
Lecturer / CSE Rajalakshmi Engineering College Thandalam, Chennai – 602 105
Mail your suggestion to bhuvangates@yahoo.com, bhuvangates@gmail.com, admin@bhuvangates.com
Visit my site www.bhuvangates.com Steps to Connect Visual Basic & Oracle
1. Select SQL Plus from the Start menu.
2. Enter the User Name, Password and Host String.
3. Create the table (eg. Employee).
Visit www.bhuvangates.com for more tutorials
4. Select the Microsoft Visual Basic 6.0 from the Start menu.
5. Select the Project type as Standard EXE and click Open.
Visit www.bhuvangates.com for more tutorials
6. Create the form with relevant controls. Control Text Box Text Box Option Button Option Button DTPicker Combo Box Combo Box Text Box Command Button Command Button Command Button Command Button Command Button Command Button Name txtEmpCode txtEname optMale optFemale dtpDob cboDesig cboDept txtSalary cmdAdd cmdView cmdEdit cmdDelete cmdClear cmdExit
7. For placing the DTPicker control, go to Project Components (or) press Ctrl+T and select the Microsoft Windows Common Controls-2.6.0 (SP3) from the Components and click OK to place in the Toolbox.
Visit www.bhuvangates.com for more tutorials
8. Now the form look like as follows.
9. Change the form name as frmEmployee and project name as prjEmployee. 10. Place the ADO Data Control by selection the Project Ctrl+T. Components (or) by pressing
Visit www.bhuvangates.com for more tutorials
11. From the list of available components check the Microsoft ADO Data Control 6.0 (SP3) (OLEDB).
12. From the Toolbox double click the Adodc control to place in the form.
13. Select the Adodc and right click. Then select ADODC Properties.
Visit www.bhuvangates.com for more tutorials
14. In the Property Pages dialog box click the Use Connection String radio button and click the Build button.
15. It opens the Data Link
A tutorial by B.BHUVANESWARAN
Lecturer / CSE Rajalakshmi Engineering College Thandalam, Chennai – 602 105
Mail your suggestion to bhuvangates@yahoo.com, bhuvangates@gmail.com, admin@bhuvangates.com
Visit my site www.bhuvangates.com Steps to Connect Visual Basic & Oracle
1. Select SQL Plus from the Start menu.
2. Enter the User Name, Password and Host String.
3. Create the table (eg. Employee).
Visit www.bhuvangates.com for more tutorials
4. Select the Microsoft Visual Basic 6.0 from the Start menu.
5. Select the Project type as Standard EXE and click Open.
Visit www.bhuvangates.com for more tutorials
6. Create the form with relevant controls. Control Text Box Text Box Option Button Option Button DTPicker Combo Box Combo Box Text Box Command Button Command Button Command Button Command Button Command Button Command Button Name txtEmpCode txtEname optMale optFemale dtpDob cboDesig cboDept txtSalary cmdAdd cmdView cmdEdit cmdDelete cmdClear cmdExit
7. For placing the DTPicker control, go to Project Components (or) press Ctrl+T and select the Microsoft Windows Common Controls-2.6.0 (SP3) from the Components and click OK to place in the Toolbox.
Visit www.bhuvangates.com for more tutorials
8. Now the form look like as follows.
9. Change the form name as frmEmployee and project name as prjEmployee. 10. Place the ADO Data Control by selection the Project Ctrl+T. Components (or) by pressing
Visit www.bhuvangates.com for more tutorials
11. From the list of available components check the Microsoft ADO Data Control 6.0 (SP3) (OLEDB).
12. From the Toolbox double click the Adodc control to place in the form.
13. Select the Adodc and right click. Then select ADODC Properties.
Visit www.bhuvangates.com for more tutorials
14. In the Property Pages dialog box click the Use Connection String radio button and click the Build button.
15. It opens the Data Link