在VB中利用DataShape技术构建层次记录集(软件报)_这是为什么呢？_百度空间(国外英语资料).docVIP

在VB中利用DataShape技术构建层次记录集(软件报)_这是为什么呢？_百度空间(国外英语资料) The use of DataShape technology to build the level of record set in VB (software _ report) is this why? _ Baidu Space Center my homepage friends news news station: no new message reminding request No new message alert system notice: 5 new ddingsoft| dress | set | exit which is why? Awesome home I love QINLE View Article Using DataShape technology to build hierarchical record set (software newspaper) in VB , 09 2009, 13:39 on Thursday, 10 Building hierarchical record sets in VB using DataShape Technology Wu Jun1 I. Introduction In the development of database applications, you often encounter the relevant records displayed in a hierarchical structure. For example, the distribution of employees in each department of the companys organizational structure is shown, such as showing the details of all customers over a period of time Fine purchase record entry. In general, these data exist in the database with two separate data tables, so you need to establish the connection between the two data tables before presenting the actual data to the user as required Conventional methods are implemented using the Join syntax in the SQL statement. After the establishment of the connection, and then through the cycle, recursion and other algorithms to complete the presentation of the interface. On the face of it, such implementations do meet the requirements of functionality, but after careful analysis, it is not an effective way to implement them. First, assume that what you want to get is a customer purchase list With the Join statement will find the returned records contains a large number of repeat customers were recorded in the network environment, these duplicate records will increase a lot of network traffic; second, when you get the record set, also need to A reasonable algorithm for rendering records, if the algorithm is not good, coupled with the large number of records displayed in the client will cause some delay. Therefo