Private Homepage of Stephan Brenner
I wrote a small sample application to test MIDL for implementing applications communicating via Local Remote Procedure Calls (LRPC).
On Code Project there is an excellent example for doing RPC via TCP. LRPC instead directly uses the Runtime API. Because of that it is much more powerful.
Source Code: LrpcExample.zip (unmanaged C++, VS2005)
In web pages it is impossible to display big lists like the desktop applications (e.g. Windows Explorer) do. You have to take attention of the limited bandwith and the rather slow rendering of the web browser. The solution is to devide the “big list” into pages with “sub lists”. This is how search engines like Google work.
There is an MSDN article which gives a rough overview of the technique behind.
Use SQL statements like these to realize paging:
SELECT TOP $$$PagesSize$$$ CustomerID,CompanyName,ContactName,
ContactTitle
FROM
(SELECT TOP $$$CurrentPageNumber * PageSize$$$
CustomerID,CompanyName,ContactName,
ContactTitle
FROM
Customers AS T1 ORDER BY ContactName DESC)
AS T2 ORDER BY ContactName ASC