In the past two days, I have been studying the DataGrid and the new brushless NEX technology. I want to create a control similar to the DataGrid, which has been basically formed yesterday.
The basic idea is as follows:
1. Discard the control of the Microsoft DataGrid server and use the table to write the control.
2. After the first operation, the client sends the table name and field, as well as the start and end positions, and returns the total number to the client before the dataset XML document. Then, commit Crip binds the XML document.
3. Implement paging. Through rownum (Oracle) or top N (sqlserver), the server sends XML documents to the client only at the start and end positions from the client.
4. Select a row.
5. Sort data. For the sake of speed, I used HTC and scrip for implementation, and only sorted at the front end.
The function has been completed. Oracle and SQL server have passed the test as follows: