OrderID 10348 10365 10367 10375 10380 10390 10394 10400 10405 10415 10418 10420 10421 OrderID 10348 CustomerID WANDK EmployeeID 4 OrderDate 12/8/1995 12:00:00 AM RequiredDate 1/5/1995 12:00:00 AM ShippedDate 12/16/1994 12:00:00 AM ShipVia 2 Freight 1 ShipName Die Wandernde Kuh ShipAddress Adenauerallee 900 ShipCity Stuttgart ShipRegion ShipPostalCode 70563 ShipCountry Germany [1 - 13 : 633]

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.