Hi all,
I need assistantance exporting my grid to c: on the server
my code
Protected Sub btnExportExcel_Click(sender As Object, e As EventArgs)
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv")
Response.Charset = ""
Response.ContentType = "application/text"
GridView1.AllowPaging = False
GridView1.DataBind()
Dim sb As New StringBuilder()
For k As Integer = 0 To GridView1.Columns.Count - 1
'add separator
If Not String.IsNullOrEmpty(GridView1.Columns(k).HeaderText) Then
sb.Append(GridView1.Columns(k).HeaderText + ","c)
End If
Next
'append new line
sb.Append(vbCr & vbLf)
For i As Integer = 0 To GridView1.Rows.Count - 1
For k As Integer = 0 To GridView1.Columns.Count - 1
'add separator
If Not String.IsNullOrEmpty(GridView1.Rows(i).Cells(k).Text) Then
sb.Append(GridView1.Rows(i).Cells(k).Text + ","c)
End If
Next
'append new line
sb.Append(vbCr & vbLf)
Next
Response.Output.Write(sb.ToString())
Response.Flush()
Response.[End]()
Response.WriteFile(path)
End Sub
Thank you