Gridview with export data in .Net Core

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nikunj Satasiya9y ago
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.Count; 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();
    }
}