Gridview with export data in .Net Core

Question

Hi How to use gridview with export data in .Net Core.

Nikunj Satasiya · Answer

You Should Try This.... //Bind GridControl Public void GetEmployee() { DataTable dt = new DataTable(); dt.Columns.Add( EmpId  typeof (Int32)); dt.Columns.Add( EmployeeName  typeof ( string )); dt.Columns.Add( Education  typeof ( string )); dt.Columns.Add( Technology  typeof ( string )); dt.Rows.Add(1 Nikunj Satasiya  B.Tech  Asp.Net ); dt.Rows.Add(2 Hiren Dobariya  B.Tech  Asp.Net ); dt.Rows.Add(3 Vivek Ghadiya  B.Tech  iOS ); dt.Rows.Add(4 Pratik Pansuriya  B.Tech  Android ); dt.Rows.Add(5 Shruti Patel  MCA  Asp.Net ); //Give datasource to Grid YourGridConrol1.DataSource = dt; YourGridConrol1.DataBind(); } Click on Export Button protected void btnExporttoExcel_Click( object sender EventArgs e) { Response.ClearContent(); Response.Buffer = true ; Response.AddHeader( content-disposition  string .Format( attachment; filename={0}  Your-File-Name.xls )); Response.ContentType = application/ms-excel ; StringWriter str = new StringWriter(); HtmlTextWriter HtmlText = new HtmlTextWriter(str); //str is object of StringWriter YourGridConrol1.AllowPaging = false ; GetEmployee(); //Change the Header Row back to white color YourGridConrol1.HeaderRow.Style.Add( background-color  #FFFFFF ); //Applying stlye to gridview header cells for ( int i = 0; i { YourGridConrol1.HeaderRow.Cells[i].Style.Add( background-color  #df5015 ); } YourGridConrol1.RenderControl(HtmlText); // HtmlTex is object of HtmlTextWriter class Response.Write(str.ToString()); Response.End(); } Page Load //Load data into Grid protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { BindGridview(); } }