Output question

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

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

James

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

Any ideas code-wise for me?

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)

VB Code:

'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

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