Am faced with a challenge today and would like some input before I start my project.
Need to create a Desktop Purchase Order program - using vb.net/Winforms / SqlServer.
I am able to handle the programming but have one point of concern in the User Interface Design and would like some input from others who have probably gone through this before.
Here's my concern...
Over a period of time there could be 1000's of purchase orders. I would like to display all orders on a Grid but my concern is the amount of data going across the network to populate the grid using SQL statement like :
SELECT PoNum, VendorName, OrderDate,Amount FROM Orders.
This will bring every row from the Database across the network to the Workstation and will take time to populate the Grid.
I could use database paging as I have done before in ASP.Net but that limits the user somewhat with regard to ease of finding and viewing previous orders.
How do companies with huge databases (Banks, Airlines, Etc) browse their customer database? I'm open to any suggestions here.