export gridview to excel เป็นภาษาไทยไม่ได้ค่ะ 2 gridview โค้ดเหมือนกันแต่อ่านภาษาไทยได้แค่อันเดียว งงมากเลย

        protected void btnExcel_Click(object sender, ImageClickEventArgs e)
        {
            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Employees.xls"));
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            MyGridView.AllowPaging = false;
            MyGridView.DataBind();

            MyGridView.HeaderRow.Style.Add("background-color", "#FFFFFF");

            for (int i = 0; i < MyGridView.HeaderRow.Cells.Count; i++)
            {
                MyGridView.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
            }
            int j = 1;

            foreach (GridViewRow gvrow in MyGridView.Rows)
            {
                gvrow.BackColor = Color.White;
                if (j <= MyGridView.Rows.Count)
                {
                    if (j % 2 != 0)
                    {
                        for (int k = 0; k < gvrow.Cells.Count; k++)
                        {
                            gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
                        }
                    }
                }
                j++;
            }
            MyGridView.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();
        }
        protected void btnWord_Click(object sender, ImageClickEventArgs e)
        {
            MyGridView.AllowPaging = false;
            MyGridView.DataBind();
            Response.ClearContent();
            Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Employees.doc"));
            Response.Charset = "";
            Response.ContentType = "application/ms-word";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            MyGridView.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();
        }