Cell XML ADO
---- Building an enterprise-level report design plan
The rise of information construction will bring new, huge business opportunities to enterprises, so use reliable, efficient, fast Internet access to information, and carry out information management is a wise choice of enterprises, and it is also an inevitable trend in the development of the informationization era. The business and management of enterprises provide productive information solutions have become an unshirkable responsibility of the majority of software development companies.
However, the corresponding problem is coming. How to ensure the goal promotion and effective? How to ensure the high quality of the product? Wait a series of issues, will directly be directly related to the success or failure of enterprise informationization, implementation of control, etc. Once the development information system fails, the cost is very huge, looking for stable efficient and easy to use and high-customized development underlying is a shortcut to reducing the risk. Here we introduce a reasonable and efficient connection to the three-story structure "Cell ADO", hoping to provide some help to demand design and developers.
Lightweight Cell:
Cell is a third-party control (ActiveX) specially used in UFAS Company. It is a convenient and powerful client report interface control. It uses its leading enterprise-level report design tool to make its user's business solutions leading, and bring users a stable platform and robust tool set to help customers expand existing delivery results, through Cell service. More users. Its most prominent is its complex statement custom function and a large number of cell-based formats, with this expert Cell, can display the most complex statements of format. At the same time, he also supports charts, cell controls, and custom formulas. The control has a good performance in multiple large software projects, and the overall feeling of people in the application of Cell is light and sharp. For the report project of the three-story structure, it is flexible with Cell to make a layer, and his advantage is as follows:
l Report Designer's greatly improved report design function, and accelerate the development and maintenance process by realizing reuse of common report files and report formats;
l The full client report and the digital signature feature allow the user to get the highest operating efficiency at the client, minimize the loss of the network delay.
l More Tight web application integration features, including comprehensive .NET support and fast refresh mode for massive data.
l Fully open custom interfaces to maximize user customization. Built-in a complete set of custom functions and formula systems.
l Unified compatible data types and event interfaces, making it equally stable in different integrated development environments.
Under the XML:
Expansion Markup Language (XML) is the first choice for data exchange between enterprises. He provides an open standard for enterprise e-commerce for realization, and efficient enterprises, which will bring SMEs into e-commerce. XML guarantees that the portability of data between trading partners is a wave of unstoppable in the future. It is like a chain link to link all levels in the three-layer structure.
Simple and easy to use ADO:
ADO is Microsoft designed for the latest and most powerful data access example OLE DB, which is an application layer interface that is easy to use. His most important advantage is easy to use, fast, memory spending less and small disk remains. I believe that there is already a considerable developer's access to ADO and other data access objects, but I still have to reiterate it here, because ADO is a "Component Object Model" (COM) interface to access storage in a unified manner Data in different information sources, its advantage will highlight the performance of the data in the web transfer process. Today, ADO is undoubtedly a must option in the B / S structure prevail. In particular, ADO. NET will provide perfect support for web applications of distributed architectures, using ADO.NET's characteristics of the objective architecture that can be greatly facilitated for development. This is very worthwhile to pay attention to the programmer developed under the .NET framework.
Solution Frame
Database data is required to be able to complete data binding in the process of client implementation, 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. In addition, it openly text-based format allows it to use HTTP protocols like HTML, and does not require changes to existing networks. Of course, this is also due to the congenital immunity of binary data. XML connects the entire three-layer structure, which is a carrier of all data in the system. As a link to connect Cell and ADO, it will play a full-time energistic structure. This is a key issue that is related to the smoothness of the entire system. Another key is the data analysis algorithm, but it doesn't want to say more here, its complexity is not easy to say. He is the upper building of the Cell ADO platform, which is the core of the intermediate layer. It is also the core competitiveness of the software company. The Cell Ado platform provides underlying guarantees and interface support for the upper floor, which is the basis for improving product robustness. The data flow is as follows:
Database data is required to be able to complete data binding in the process of client implementation, 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. In addition, it openly text-based format allows it to use HTTP protocols like HTML, and does not require changes to existing networks. Of course, this is also due to the congenital immunity of binary data. XML connects the entire three-layer structure, which is a carrier of all data in the system. As a link to connect Cell and ADO, it will play a full-time energistic structure. This is a key issue that is related to the smoothness of the entire system. Another key is the data analysis algorithm, but it doesn't want to say more here, its complexity is not easy to say. He is the upper building of the Cell ADO platform, which is the core of the intermediate layer. It is also the core competitiveness of the software company. The Cell Ado platform provides underlying guarantees and interface support for the upper floor, which is the basis for improving product robustness.
The data flow is as follows:
During the data flow, first ADO establishes contacts with the data source through the Connection transaction, and creates interface objects, such as: RecordSet. Data can be directly connected to the interface from the database, of course, because of the lack of flexible, this approach is abandoned by many people because your data analysis and excavation modules will be useless. The data is probably within two, text type and binary flow type, I have been suggested that the data can be displayed by XML transmission mode to the client, and the client can make a simple organization. SetcellString and SetCellDouble in Cell can display data according to the value and character classification, and its READFROMBUFFER interface can accept binary stream data. Obviously, through the above introduction you will find that under the Cell ADO platform, you can simply build a report design scheme as long as you care about the data processing and analysis modules. With the continuous upgrade of Cell and the launch of ADO.NET, the feasibility of this combination will continue to improve. I hope they can play a more active role in the information construction of the company.
