Not able to download hyperlink from excel cell using ASP.NET

See more:

ASP.NET

Hi,

i am exporting data from asp.net gridview to excel for some data.

In that, one of the cell which contains hyperlink in the excel sheet cell.

when i click the hyperlink in the excel, then i received popup like "Microsoft Excel Security Notice" followed by "cannot download the information you requested".

How to solve this problem.

SQL Query to map with gridview

IF @Spd_Type='Exportdata' 
Begin 

Create Table #Pkids(ID Int) 
Insert into #Pkids 
SELECT R.i.query('Pkid').value('.', 'VARCHAR(20)') 
FROM @Spd_XML.nodes('/DocumentElement/Test') R(i) 
Select

EmpNo,
Case When EmpNo ='' Then '' Else 'http://sas02.sanet.sam.intranet/D2/servlet/Download?auth=basic&event_name=d2_view&_docbase=uatprjarea&id=09139&version=CURRENT' End PDFEmpNo, 
Empname,
Dept, 
From tbl_Student 
Where A.Pkid in(Select * from #Pkids)


End

ASP.NET

<asp:GridView ID="grdEmp" AutoGenerateColumns="false" HeaderStyle-BackColor="Yellow"
ShowHeader="false" runat="server">
<Columns>

<asp:TemplateField>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "EmpName")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lblPOPDF" runat="server" Text='<%# Eval("EmpNo") %>' Visible="false" />
<asp:HyperLink ID="lnkbtnDownload" NavigateUrl='<%# DataBinder.Eval(Container.DataItem, "POFEmpNo")%>'
Text='<%# Eval("EmpNo") %>' runat="server"></asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "Dept")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

ASP.NET.vb Code

Dim XML As String
XML = Session("XML").ToString

If XML = "<DocumentElement />" Then
Session("XML") = "NULL"
End If

Conn.sqlCmd.Parameters.AddWithValue("@Spd_Type", "ExportData")
Conn.sqlCmd.Parameters.AddWithValue("@Spd_XML", Session("XML").ToString)
ds = Conn.XcuteResult(str, CommandType.StoredProcedure, "SPD_StudentInfo")

grdEmp.DataSource = ds
grdEmp.DataBind()

Finally when i click the hyperlink i getting following error message.

Error : "cannot download the information you requested".

what is the solution for this..