how to download files from datalistview?

Question

when i clicking link button in datalist view the file should be download.can any one give me the reference..

Sanjeeb Lenka · Answer

hi, i checked your code . In that you are not storing the file any where. you are just taking the name,size and extension of the file and storing it to db. so its not storing the file physically. for that you have to store your file in your application in a folder or you can store the file in db. try to store the file in application folder . then you can able to download it from datalist by passing the path of the file. refer to this link http://www.aspdotnet-suresh.com/2012/02/saveupload-files-in-folder-and-download.html

selva kumar · Answer

here is my table struct.all fields are declared as varchar,T_Id as int identy(1,1)..

Jaganathan Bantheswaran · Answer

How did you save the file? are you saving file content in DB or only file path? What is T_ID?

selva kumar · Answer

i can't get clear idea.Can u pls modify my code.. Source: BorderStyle="Solid" BorderWidth="1px" CellPadding="3" Font-Names="Verdana" Font-Size="Small" GridLines="Horizontal" RepeatDirection="Horizontal" RepeatColumns="0" Width="700px" ForeColor="Black" Height="6px" UseAccessibleHeader="True" OnItemCommand="DataList1_ItemCommand"> HorizontalAlign="Center" VerticalAlign="Middle" /> E-Book ' Visible="false" > File Name: '> File Type : '> File Size : '> Download: ' CommandName="click" Text="click Here"> --%> C#: public partial class Staff_Uploadbooks : System.Web.UI.Page { SqlConnection Con; SqlCommand Cmd; SqlDataAdapter Sdap; protected void Page_Load(object sender, EventArgs e) { Con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=studentmgmt;Integrated Security=True"); if (!IsPostBack) { datalistbind(); } } protected void Button1_Click(object sender, EventArgs e) { try { string filename = Path.GetFileName(FileUpload1.PostedFile.FileName); string filetype = Path.GetExtension(FileUpload1.PostedFile.FileName); Stream str = FileUpload1.PostedFile.InputStream; int size1 = (int)str.Length; double doubl = Convert.ToDouble(size1); double size2 = doubl / 1048576; Label size = new Label(); size.Text = Convert.ToString(size2) + "MB"; Cmd = new SqlCommand("insert into Staffuploads(FileName,ContentType,Size) values(@FileName,@ContentType,@Size)", Con); Cmd.Parameters.AddWithValue("@FileName", filename); Cmd.Parameters.AddWithValue("@ContentType", filetype); Cmd.Parameters.AddWithValue("@Size", size.Text); Cmd.Connection = Con; Con.Open(); Cmd.ExecuteNonQuery(); } catch { } finally { Con.Close(); datalistbind(); } } protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "click") { string file = e.CommandArgument.ToString(); } } public void datalistbind() { try { Con.Open(); Sdap = new SqlDataAdapter("Select T_ID,[Filename],ContentType,Substring([Size],1,4) Size From Staffuploads", Con); DataSet Ds = new DataSet(); Sdap.Fill(Ds); DataList1.DataSource = Ds.Tables[0]; DataList1.DataBind(); } catch { } finally { Con.Close(); } } }

Jaganathan Bantheswaran · Answer

Hi, Try something like this when you click on that link, Response.ContentType = "application/pdf"; //Response.ContentType = "Application/msword"; Response.AppendHeader("Content-Disposition", "attachment; filename=MyFile.pdf"); Response.TransmitFile(Server.MapPath("~/Files/MyFile.pdf")); Response.End();

selva kumar · Answer

Uploaded file from database neither pdf nor word.by using asp.net link button.

Jaganathan Bantheswaran · Answer

Which file do you want to download?

how to download files from datalistview?

Answers (7)