Tags for this article: adc, data source, html, scripting, tdc, tutorial
So far we have discussed about various types of tags and objects of HTML documents but haven’t come across any methodology which can control the data embedded in them. In a simple HTML document the web browser cannot separate data from the content and thus the user can’t manage and manipulate it. In order to solve this issue the concept of Data Binding was introduced. Via data binding one can associate the data of a database with the HTML pages. Once the web page is downloaded and opened by the web browser the data associated with that page can be differentiated from the any other content and the user has full control over it. Data binding offers a vast array of new methods and properties for HTML tags which can be used to associate a database with the web page.
Data binding involves three basic steps:
1) Adding a data source to the HTML document
2) Binding HTML elements to the data source
3) Developing scripts to control the bonded database table
Adding the Data Source object to the web page
The first and foremost step towards data binding is to identify the data source and add it to the web page. In order to accomplish this The Data Source Objects (DSO) are used. DSOs are provided by Microsoft and are used for supplying data to the web browser. In order to do this, the DSO identifies the data source through various methods such as SQL queries, URLs etc.
Apart from this DSOs are also used to manipulate the data. It is used to give the user complete control over the data. DSO offers a large number of properties, events and methods in order to accomplish this.
The Microsoft’s Internet Explorer comes with two built-in DSOs. The first one is the Advanced Data connector (ADC) and the other one is the Tabular Data Control (TDC). ADC is meant to access the database via server and ODBC (Open Database Connectivity) components. TDC is used to access tabular data stores in the form of comma-delimited text files. Without the DSO no web page can get and access the data.
Binding HTML elements to the data source
It is very crucial to associate the HTML page to the Data source Object. With the help of DATASRC and DATAFLD attributes, the data can be bonded with the HTML elements. The DATASRC refers to the Data Source Object (DSO) and the DATAFLD refers to a specific column of the database. Both of them have to be defined in the HTML code in order to associate a database table with the web page.
Scripting of Data Source Objects
Once the data source has been identified and associated with the HTML document, the final step is to create a script for that which will allow the user to control the data in a particular manner. Without scripting the user cannot manipulate the data. Scripting is done by using different types of properties and methods of Data Source Object.