1 / 10

DATABASE SYSTEM

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.

hansel
Download Presentation

DATABASE SYSTEM

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATABASE SYSTEM VB LINK TO MS-SQL

  2. 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

  3. 6.5 Database Link To Microsoft SQL Select Microsoft ADO Data Control 6.0 (OLEDB). Then click command button Apply and OK.

  4. 6.5 Database Link To Microsoft SQL The Adodc control/object will appear at the ToolBox

  5. 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. 6.5 Database Link To Microsoft SQL Select the ConnectionString and Property Pages will appear.

  7. 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.

  8. 6.5 Database Link To Microsoft SQL Select or enter Server name then Select the Database on the server

  9. 6.5 Database Link To Microsoft SQL Select the RecordSource – Patient

  10. 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.

More Related