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(); } }

Gridview with export data in .Net Core

Answers (1)