Hi democloud,
Refer below sample code.
HTML
<asp:GridView runat="server" ID="GridView1" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="OrderDate" HeaderText="OrderDate" />
<asp:BoundField DataField="Country" HeaderText="Country" />
</Columns>
</asp:GridView>
<asp:Button ID="Button1" Text="Export" runat="server" OnClick="btnToCSV_Click" />
Namespaces
C#
using System.Data;
using System.Text;
VB.Net
Imports System.Data
Imports System.Text
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
new DataColumn("OrderDate", typeof(DateTime)),
new DataColumn("Country",typeof(string)) });
dt.Rows.Add(1, new DateTime(2019, 01, 01), "United States");
dt.Rows.Add(2, new DateTime(2018, 02, 05), "\"\"");
dt.Rows.Add(3, new DateTime(2016, 08, 29), "");
dt.Rows.Add(4, new DateTime(2017, 11, 15), null);
GridView1.DataSource = dt;
GridView1.DataBind();
ViewState["Data"] = dt;
}
}
protected void btnToCSV_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";
DataTable dt = ViewState["Data"] as DataTable;
DataTable dt2 = new DataTable();
for (int i = 0; i < dt.Columns.Count; i++)
{
dt2.Columns.Add(dt.Columns[i].ColumnName, typeof(string));
}
for (int i = 0; i < dt.Rows.Count; i++)
{
dt2.ImportRow(dt.Rows[i]);
dt2.Rows[i]["OrderDate"] = Convert.ToDateTime(dt2.Rows[i]["OrderDate"]).ToString("yyyy/MM/dd");
}
this.GridView1.DataSource = dt2;
this.GridView1.DataBind();
StringBuilder sb = new StringBuilder();
for (int k = 0; k < GridView1.Columns.Count; k++)
{
sb.Append(GridView1.Columns[k].HeaderText + ',');
}
sb.Append("\r\n");
for (int i = 0; i < GridView1.Rows.Count; i++)
{
for (int k = 0; k < GridView1.Columns.Count; k++)
{
string cell = GridView1.Rows[i].Cells[k].Text.Trim().Replace(" ", "").Replace(""", "");
sb.Append(" " + cell + ',');
}
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim dt As DataTable = New DataTable()
dt.Columns.AddRange(New DataColumn(2) {New DataColumn("Id", GetType(Integer)), New DataColumn("OrderDate", GetType(DateTime)), New DataColumn("Country", GetType(String))})
dt.Rows.Add(1, New DateTime(2019, 1, 1), "United States")
dt.Rows.Add(2, New DateTime(2018, 2, 5), """""")
dt.Rows.Add(3, New DateTime(2016, 8, 29), "")
dt.Rows.Add(4, New DateTime(2017, 11, 15), Nothing)
GridView1.DataSource = dt
GridView1.DataBind()
ViewState("Data") = dt
End If
End Sub
Protected Sub btnToCSV_Click(ByVal sender As Object, ByVal e As EventArgs)
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv")
Response.Charset = ""
Response.ContentType = "application/text"
Dim dt As DataTable = TryCast(ViewState("Data"), DataTable)
Dim dt2 As DataTable = New DataTable()
For i As Integer = 0 To dt.Columns.Count - 1
dt2.Columns.Add(dt.Columns(i).ColumnName, GetType(String))
Next
For i As Integer = 0 To dt.Rows.Count - 1
dt2.ImportRow(dt.Rows(i))
dt2.Rows(i)("OrderDate") = Convert.ToDateTime(dt2.Rows(i)("OrderDate")).ToString("yyyy/MM/dd")
Next
Me.GridView1.DataSource = dt2
Me.GridView1.DataBind()
Dim sb As StringBuilder = New StringBuilder()
For k As Integer = 0 To GridView1.Columns.Count - 1
sb.Append(GridView1.Columns(k).HeaderText + ","c)
Next
sb.Append(vbCrLf)
For i As Integer = 0 To GridView1.Rows.Count - 1
For k As Integer = 0 To GridView1.Columns.Count - 1
Dim cell As String = GridView1.Rows(i).Cells(k).Text.Trim().Replace(" ", "").Replace(""", "")
sb.Append(" " & cell & ","c)
Next
sb.Append(vbCrLf)
Next
Response.Output.Write(sb.ToString())
Response.Flush()
Response.End()
End Sub
Screenshot
