Excel Download

OrderID
10430
10436
10438
10440
10441
10443
10444
10445
10446
10447
10448
10449
10451
OrderID10430
CustomerIDERNSH
EmployeeID4
OrderDate3/2/1995 12:00:00 AM
RequiredDate3/16/1995 12:00:00 AM
ShippedDate3/6/1995 12:00:00 AM
ShipVia1
Freight458.78
ShipNameErnst Handel
ShipAddressKirchgasse 6
ShipCityGraz
ShipRegion
ShipPostalCode8010
ShipCountryAustria

bottom next goreload download

[1 - 13 : 572]

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.


Send comments on this topic.
Copyright (c) 1998-2006 ASP-db