How to change Link button fore color using jquery while export data from gridview to ExcelRSS

1 reply

Last post Feb 17, 2017 05:47 AM by Cathy Zou

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

- Reply
shiva jav
None

0 Points

2 Posts

How to change Link button fore color using jquery while export data from gridview to Excel

Feb 16, 2017 10:04 AM|shiva jav|LINK

I have aspx application, I have used gridview inside dvData div. gridview header has link button. on exporting to excel, i need link button fore color has to change. anyone please help me.

In Jquery function :

function Search_ExportToExcel() {
var data = $("#dvData").html();
data = escape(data);
$('body').prepend("<form method='post' action='exportPage.aspx' style='top:-3333333333px;' forecolor:'white' id='tempForm'><input type='hidden' name='data' value='" + data + "' ></form>");
$('#tempForm').submit();
$("tempForm").remove();
return false;

}

In code behind :

protected void Page_Load(object sender, EventArgs e)
{
string data = Request.Form["data"];
data = HttpUtility.UrlDecode(data);
Response.Clear();
string filename = "QAP_SearchReport_" + DateTime.Now.ToString() + ".xls";
Response.AddHeader("content-disposition", "attachment;filename=" + filename + "");
Response.Charset = "";
Response.ContentType = "application/excel";
HttpContext.Current.Response.Write(data);
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}

Please help me

Cathy Zou

Star

8650 Points

2882 Posts

Re: How to change Link button fore color using jquery while export data from gridview to Excel

Feb 17, 2017 05:47 AM|Cathy Zou|LINK

Hi shiva jav,

Please try to change the forecolor and call your Search_ExportToExcel() method in behind code.

In aspx:

<!DOCTYPE html>
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-3.1.1.js"></script>
    <script>
        function Search_ExportToExcel() {
            var data = $("#dvData").html();
            data = escape(data);
            $('body').prepend("<form method='post' action='exportPage.aspx' style='top:-3333333333px;' forecolor:'white' id='tempForm'><input type='hidden' name='data' value='" + data + "' ></form>");
            $('#tempForm').submit();
            $("tempForm").remove();
            return false;
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div id="dvData">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
                <Columns>
                    <asp:TemplateField ItemStyle-Width="100px" HeaderText="ItemName">
                        <HeaderTemplate>
                            <asp:LinkButton ID="LinkButton1" Text="Linkbutton" runat="server"></asp:LinkButton>
                        </HeaderTemplate>
                        <ItemTemplate>
                              <asp:Label ID="txtItemsName" runat="server"
                                Text='<%# Eval("ItemsName")%>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" />
       
    </form>
</body>
</html>

In behind code:

protected void Button1_Click(object sender, EventArgs e)
        {
            var button = GridView1.HeaderRow.FindControl("LinkButton1") as LinkButton;
            button.ForeColor = System.Drawing.Color.Red;
            Page.ClientScript.RegisterStartupScript(this.GetType(), "export", "Search_ExportToExcel()", true);
 
        }

Best Regards

Cathy

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

‹ Previous Thread|Next Thread ›