OrderID 10277 10329 10337 10338 10348 10349 10353 10356 10357 10358 10360 10363 10364 OrderID 10277 CustomerID MORGK EmployeeID 2 OrderDate 9/9/1994 12:00:00 AM RequiredDate 10/7/1994 12:00:00 AM ShippedDate 9/13/1994 12:00:00 AM ShipVia 3 Freight 125.77 ShipName Morgenstern Gesundkost ShipAddress Heerstr. 22 ShipCity Leipzig ShipRegion ShipPostalCode 04179 ShipCountry Germany [1 - 13 : 710]

Download as Excel

<script language="vb" runat="server"> Sub Page_Load(Source as Object, E as EventArgs) Dim XL As New Tornado.Z() Dim qp as string = "U=28| M=Dh| S=13| PS=13| D=nwind.mdb| Q=Orders| df=0,1,2,3,4,5,6" qp &= "| Gdf=0| DownloadParams=excel=true| ni=b5,download| Th=Tit=Excel Download" XL.dbQP= XL.ASPdbNET() End Sub </script>

In this 'Simple' download sample application, you only need one line of code to display 4 fields with a pagesize of 10 and download only 2 fields of the entire recordset.