Hyperlink in a griddview

[giveDsolution]

Hope any one of can solve my problem. I have hyperlink button in a gridview in a templete column.Hyperlink represents the uploaded file. On Clicking the hyperlink it will open a dialouge box for downloading that file.

IT is not compulsory that it will be a hyperlink ...according to ur suitable way u can suggest what i have to use.

[giveDsolution]

It is So Confusing or wht ........no respond at all

[prabunewindia]

hi friend,
acually where is that uploaded file?
in database or in system?
in database means in which format u stored it?
reply
i can guide u to solve it
Prabu

Hope any one of can solve my problem. I have hyperlink button in a gridview in a templete column.Hyperlink represents the uploaded file. On Clicking the hyperlink it will open a dialouge box for downloading that file.

IT is not compulsory that it will be a hyperlink ...according to ur suitable way u can suggest what i have to use.

[giveDsolution]

hi friend,
acually where is that uploaded file?
in database or in system?
in database means in which format u stored it?
reply
i can guide u to solve it
Prabu

In Database .......Actually I have found the solution anyways u told me the solution ......may that will be a better one

[prabunewindia]

store the file as byte[]

get that from database and code

response.AddHeader("Content-Disposition", "attachment;filename=" + dr["Flname"]);
response.ContentType = Convert.ToString(dr["ContentType"]);
Int32 b2 = Convert.ToInt32(dr["ContentSize"]);
response.OutputStream.Write(((byte[])(dr["Contents"])), 0, b2);

this will show u the dialog window
plz share ur solution
Prabu

In Database .......Actually I have found the solution anyways u told me the solution ......may that will be a better one

[giveDsolution]

store the file as byte[]

get that from database and code

response.AddHeader("Content-Disposition", "attachment;filename=" + dr["Flname"]);
response.ContentType = Convert.ToString(dr["ContentType"]);
Int32 b2 = Convert.ToInt32(dr["ContentSize"]);
response.OutputStream.Write(((byte[])(dr["Contents"])), 0, b2);

this will show u the dialog window
plz share ur solution
Prabu

I knew it but how to use it in hyperlink........I have used this one in Linkbutton

[prabunewindia]

u can target another page using this hyperlink and pass the fileID(table primaryley value) using query string
then u get the file from that page's page load event and code to download

Prabu

I knew it but how to use it in hyperlink........I have used this one in Linkbutton

[giveDsolution]

Without using another page we can do it like this....

I have use the linkbutton.
In aspx i have write
<asp:LinkButton ID="lbtn" runat="server" Text='<%#Databinder.Eval(container.Dataitem,"vchfi lename") %>' CommandName="cmdclick" ></asp:LinkButton>

In vb,

Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs ) Handles GridView1.RowCommand
If e.CommandName = "cmdclick" Then
Dim strLink, strUserID As String
strLink = CType(CType(CType(e.CommandSource, LinkButton).Parent, DataControlFieldCell).Parent, GridViewRow).RowIndex
strUserID = GridView1.DataKeys(strLink).Value.ToString
Dim strsql = "SELECT * from T_Collaboration where vchCollaborationId='" & strUserID & "' and intDeletedStatus<>1"
Dim dr = comm.ExeReader("ConnectionString", strsql)
If dr.Read() Then
Dim length = dr("intFilesize").ToString()
Dim filename = dr("vchFilename").ToString()
Dim Data = CType(dr("imgFile"), Byte())
Dim Type = dr("vchFiletype").ToString
Response.AddHeader("Content-Disposition", "Attachment;Filename=" & filename)
Response.AddHeader("Content-Length", length)
Response.ContentType = Type
Response.BinaryWrite(Data)
Response.End()
End If
End If
End Sub


Is it ok???????

[giveDsolution]

Frds any help???????????
This is working fine in Internet Explorer 7.0 but not working in IE 6.0.
Any guess wht may be the prob?
In IE6.0 when i click the linkbutton....it goes on thrill but it works in IE 7.0.
Plz help me frds

[giveDsolution]

Seems difficult or wht?????? No Reply

[giveDsolution]

Seems difficult or wht?????? No Reply

Till now i didn't find any solution

[giveDsolution]

hellossssssss frds any idea plz