Export datatable into CSV

Question

EXPORT DATA TABLE INTO CSV IT GIVES ERROR Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.

Khargesh Rajput · Answer

this error may caused by update panel. add below code to page_load protected void Page_Load(object sender EventArgs e) { ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); scriptManager.RegisterPostBackControl(this.btnExcelExport); }

akash singh · Answer

on button click protected void Button4_Click(object sender EventArgs e) { cn = new OleDbConnection(ConnString); string a = Request.QueryString[field]; da = new OleDbDataAdapter(SELECT +a+  SDF@CCDP where SDF_BRCD=BRCD +Label1.Text+  cn); DataTable DT = new DataTable(); da.Fill(DT); StringBuilder sb = new StringBuilder(); for (int k = 0; k < DT.Columns.Count; k++) { //add separator sb.Append(DT.Columns[k].ColumnName + ''); } //append new line sb.Append(
); for (int i = 0; i < DT.Rows.Count; i++) { for (int k = 0; k < DT.Columns.Count; k++) { //add separator sb.Append(DT.Rows[i][k].ToString().Replace( ;) + ''); } //append new line sb.Append(
); } Response.Output.Write(sb.ToString()); Response.Flush(); Response.End(); }

akash singh · Answer

thanx a llot bro

akash singh · Answer

ok..thanx bro but data is showing on webpage. i want data in csv file

Daisy Princess · Answer

Can you provide the code block?