Linking Visual Basic with Microsoft SQL - Step-by-Step Guide
This guide provides a detailed process for linking a Visual Basic application to a Microsoft SQL database. Follow the steps to create your database in Chapter 9 before proceeding with the link. Learn how to use the ADO Data Control (OLEDB) to connect to your database and manipulate patient records effectively. The tutorial covers setting up the connection string, selecting the appropriate server and database, and configuring data fields such as Patient ID, IC Number, Address, and Telephone Number. Streamline your database interface with Visual Basic today!
Linking Visual Basic with Microsoft SQL - Step-by-Step Guide
E N D
Presentation Transcript
DATABASE SYSTEM VB LINK TO MS-SQL
Visual Programming Chapter 6 6.5 Database Link To Microsoft SQL (Note: You must create database at chapter 9 Ms-SQL Server before linking database with Visual Basic interface) Select Project -> Component
6.5 Database Link To Microsoft SQL Select Microsoft ADO Data Control 6.0 (OLEDB). Then click command button Apply and OK.
6.5 Database Link To Microsoft SQL The Adodc control/object will appear at the ToolBox
6.5 Database Link To Microsoft SQL Select the Adodc. Then draw the object on the form. Change the Property Name to adoPatient. Change Property Caption to Patient Record
6.5 Database Link To Microsoft SQL Select the ConnectionString and Property Pages will appear.
6.5 Database Link To Microsoft SQL Select Use Connection String and click command button Build. The Data Link Properties will appear. Then select Microsoft OLE DB Provider For SQL Server.
6.5 Database Link To Microsoft SQL Select or enter Server name then Select the Database on the server
6.5 Database Link To Microsoft SQL Select the RecordSource – Patient
6.5 Database Link To Microsoft SQL Select Data Source – adoPatient Then Select Data Field – Patient ID. Repeat the same process for the other fields – IC Number, Address and Tel No.
