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

Debasis Saha · Answer

Can you provide the code block?

Export datatable into CSV

Answers (5)