Page 246 - Open Soource Technologies 304.indd

Event Driven Programming

10.6 Summary

• Structured query language is a standard programming language used for accusing and
maintaining database.

• Data bound control, bind a control to a database properties like data source.
• Tables using import assistant in which we can populate table with data by importing data
from the file.
• Varcher (MAX) is to use the TEXT type and TEXT type data for SQL server.

• Common table Expression (CTE) is a mechanism to result of a select statement as a table
for SQL.

10.7 Keywords

BoundColumn Class: A column type for the DataGrid control that is bound to a field in a data
source.
Count Territories: It is created as a sort of temporary view that’s used just for this single select
statement. Once created, it can be queried against in the subsequent SELECT: statement, as though
it were a table.

Data Control Language (DCL): It is a computer language and a subset of SQL, used to control
access to data in a database.
DataSource: It is data-provider-independent description of a set of objects that will be loaded,
edited and saved within the user interface of application.
MSHFlexGrid: The Microsoft Hierarchical FlexGrid (MSHFlexGrid) control displays and operates
on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings
and pictures. When bound to a data control, MSHFlexGrid displays read-only data.
Recordset: It is a data structure that consists of a group of database records, and can either come
from a base table or as the result of a query to the table.

Structured Query Language (SQL): It is a standard programming language used for accessing and
maintaining a database.The key feature of the SQL is an interactive approach for getting infor-
mation from and updating a database.
Varchar: Variable Character Field is a set of character data of indeterminate length. The term
varchar refers to a data type of a field (or column) in a database management system.

1. Create Database Using Visual Database Manager.
2. Connect SQL Server from Visual Basic 6.
3. Connect VB with Microsoft Access.

240 LOVELY PROFESSIONAL UNIVERSITY