Page 226 - Open Soource Technologies 304.indd

Event Driven Programming Anil Sharma, Lovely Professional University

Unit 10: Database Fundamentals and
Connectivity Option

CONTENTS

Objectives
Introduction
10.1 The Data Control
10.2 The Data-Bound Controls
10.3 Creating Database Using Visual Database Manager
10.3.1 To Create a Database
10.3.2 Create a Table Using Visual DBA
10.3.3 To Create a Base Table
10.3.4 Populate a Table Using the Import Assistant
10.3.5 To Import Data From a File Using the Import Assistant
10.4 Connectivity of VB with Microsoft Access
10.4.1 Setting Up an ODBC Data Source
10.4.2 Sample Applications 2 and 3: Using ADO Code
10.5 SQL Server (Structured Query Language)
10.5.1 Overview
10.5.2 Getting Started with SQL Server 2005 Express
10.5.3 Connecting from Visual Dasic 6
10.5.4 Multiple Recordsets, One Connection
10.5.5 Varchar (MAX)
10.5.6 Common Table Expressions
10.5.7 Common Language Runtime Integration
10.6 Summary
10.7 Keywords
10.8 Self Assessment Questions
10.9 Review Questions
10.10 Further Readings

Objectives

After studying this unit, you will be able to:
• Understanding the data control and data bound controls
• Discuss creation of database using visual database manager
• Explain the connectivity of VB with microsoft access
• Discuss the SQL and its overview

220 LOVELY PROFESSIONAL UNIVERSITY