Output question

[Ooogaleee]

Is there an easy way to output a filled-in datagrid to Excel via code? If not, what about converting the datagrid to a printable format (such as PDF)?

If you couldn't guess, I'm trying to simply export a grid into a "printer friendly format". Any tips?

Thanks...Ooogs

[jl39775]

If your using Visual Studio.net use the Crystal Report feature.

James

[Ooogaleee]

Unfortunately, I'm not using the full .NET Studio version, just the VB.NET package solo.

Any ideas code-wise for me?

[Lord_Rat]

If it were me (and I know its not) I would have a link on the page that calls another page. This other page would loop through a data reader and output the data as a comma-seperated values file.

The following is off the top o me head and probably won't run "out - of - the - box" but it should get you on-track with how you would do it (this is in that other page)

'open the record set and assign the command results to the recordset before this point
Response.ContentType = "text/csv"
Dim DoneOnce as Boolean = False
while objRS.Read()
if not DoneOnce then
For x = 0 to objRS.fieldCount - 1
response.write(objRS.item(x).key & Microsoft.VisualBasic.vbTab)
Next
Response.Write(Microsoft.VisualBasic.vbCrLf)
DoneOnce = True
End If
For x = 0 to objRS.fieldCount - 1
response.write(objRS.item(x) & Microsoft.VisualBasic.vbTab)
Next
Response.write(Microsoft.VisualBasic.vbCrLf)
End While

[jl39775]

If you have Adobe Distiller you can create pdf files. Then have the users download them to the adobe reader plugin. They will be able to print with the plugin.

James