i have a gridview in which i have one button field. the functionality of this button field is to allow me to download docs saved in my database?but nothing happens when i hit the download button?

Question

0.00/5 (No votes)

See more:

my database contains following feilds:

SQL

autoid	        int	
pcode	    varchar(50)	
fyyear	    varchar(50)	
date	    varchar(50)	
salary	        int	
ta	        int	
contigency	int	
nrc	        int	
institcharges	int	
others	        int	
docname	    varchar(50)	
doctype	    varchar(50)	
docdata	    varbinary(MAX)

This is the code i am using to display the data in the button field:

C#

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Document Download")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            string url = GridView1.Rows[index].Cells[13].Text;
            System.IO.FileInfo file = new System.IO.FileInfo(url);
            if (file.Exists)
            {
                Response.Clear();
                Response.AppendHeader("Content-Disposition:", "attachment; filename=" + file.Name);
                Response.AppendHeader("Content-Length", file.Length.ToString());
                Response.ContentType = "application/octet-stream";
                Response.TransmitFile(file.FullName);
                Response.End();
            }
            else
            {
                Response.Write("NO FILE PRESENT");
            }
        }
    }

but when i click the button field nothing happens
note: i have linked my button field to docname data field.

Posted 4-Feb-13 20:09pm

a2ulthakur

Updated 4-Feb-13 20:14pm

_Amy

v3

Add a Solution

Comments

Sanjay K. Gupta 5-Feb-13 2:17am

add break point at
Response.TransmitFile(file.FullName);
and see the file.FullName value

a2ulthakur 5-Feb-13 2:22am

nothing in there ...i tried the breakpoints ..i just want a simple thing i want to download the file by its name (docname)from the button field in gridview my file is stored in database but i m not able to download it.

2 solutions

Solution 2

Response.TransmitFile(Server.MapPath("~C/Desktop/MIS/docs/" + fileName));
i m getting error here "Could not find a part of the path 'C:\Users\cgrt\Desktop\MIS\~C\Desktop\MIS\docs\'."

Posted 4-Feb-13 22:07pm

a2ulthakur

Comments

boogac 5-Feb-13 9:59am

when you write the full path ~ is needed ??

anyway,this is not an solution

a2ulthakur 5-Feb-13 13:42pm

ya i know this is not the solution.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2013-02-04T20:21:00

There is two ways:
1st:

C#

int index = Convert.ToInt32(e.CommandArgument);
string url = GridView1.Rows[index].Cells[13].Text;
Response.Redirect(url)

And
2nd:

C#

int index = Convert.ToInt32(e.CommandArgument);
string url = GridView1.Rows[index].Cells[13].Text;
FileInfo file = new FileInfo(url);
if (file.Exists)
{
   Response.Clear();
   Response.ClearHeaders();
   Response.ClearContent();
   Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
   Response.ContentType = "application/octet-stream";
   Response.AddHeader("Content-Length", file.Length.ToString());
   Response.WriteFile(file.FullName);
   Response.End();
}
else
{
   Response.Write("This file does not exist.");
}

Hope it works!
--Amit