Office Star Control (http://www.standsoft.com), as an excellent graphic mixing control, is very wide in the B / S architecture system. As a representation layer, it can present the document of the graphic mixed, various complex reports, can also be used as an interface to be recorded as a data acquisition, which effectively solves the document display and printing problems of the client in the B / S architecture system. In actual work, we often encounter such an occasion: the document style is unchanged, the data (including pictures) allows changes, click "Previous", "Next" button can be browsed. Database organizations are obviously the best, then how does the office star control displays data from the database in the document? How to browse data up and down? We analyze, the database is stored on the server, the office star control is in the client, requiring the client to complete data binding is unrealistic, especially for complex and irregular reports. This developer has more controlled space on data organization, analysis, and mining. The XML is to allow it to describe data in different kinds of applications due to its excellent scalability and flexibility, which is the best candidate for data transmission media. Here we introduce a data island technology. XML's data source object is also known as the data island (English abbreviation DSO). The implementation mechanism of the data island is to operate an XML document or a paragraph XML code as an object similar to a database, using a traditional manipulation of a database, such as data adding, deleting, updating, and querying. Some people also call them a database that flows on the network. On the other hand, the data island provides techniques that bind XML format data and tables, text boxes, and the like. The following is the entire scenario map: First, establish a data island First, create an XML file, take the data from the server from the server. The following is an ASP sample code: <% response.buffer = true DIM conndim connStrdim DBDIM SQL, RS 'database path DB = "db / db.mdb" set conn = server.createObject ("adodb.connection" connStr = "provider = Microsoft.jet.Oledb.4.0; data source = "& Server.mappath (" & DB & ") Conn.CreateObject (" AdoDb.Recordset ") 'Get all fields in the Cell data table SQL = "Select * from cell" rs.open SQL, CONN, 1, 1%> 'By cyclic generation XML document body
A recordset contains one or more records (lines), each record includes one or more 颍ㄗ危 1 old 鞷 Ecordset is a way to manage the database, which is fully used to manage XML documents. Using the recordset manages the first step in the XML document is to create a recordset object; then manage the data by the relevant properties and methods of the recordset object. When the external XML document is introduced through the data island technology, a recordset object is automatically created. 1. The declaration record set first defines a data island, then call an attribute of the data island to generate a recordset, and the specific syntax is similar to the following program:
