Hello

I am trying to export a datagrid to an excel file using VB.NET.
I can do it in ASP.net like this:
Dim oDS As DataSet = reports.GetDataset(StoredProcedure, oparams)
Dim DG As New DataGrid
DG.DataSource = oDS
DG.DataBind()
Dim stringWrite As New System.IO.StringWriter
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
DG.RenderControl(htmlWrite)
reports.WriteFile(stringWrite.ToString, FileName)

(where reports contains all my functions)

but this method doesnt work in VB.NET as these two lines cannot be used in VB.NET:
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
DG.RenderControl(htmlWrite)

Does any one know of an alternative cos I'm stuck!

Thanx

Bex

Ok.. worked it out... did not realise I could reference the system.web namespace in a vb.net app... I can use the code listed above! duh!