How to insert file path in text file

Question

hi, i want to insert file path in setting file or text file from browsing file upload control so pls help me. i am getting the path but unable to insert in text file. so how can i insert it ? fast reply i am waiting

Dipankar Biswas · Answer

hi.. send me ur code pls.. I'll try.. try it.. using System;using System.Data.SqlClient; using System.IO; using System.Web.UI.WebControls; string strCon = "Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGridviewData(); } } // Bind Gridview Data private void BindGridviewData() { using (SqlConnection con=new SqlConnection(strCon)) { using (SqlCommand cmd=new SqlCommand()) { cmd.CommandText = "select * from FileInformation"; cmd.Connection = con; con.Open(); gvDetails.DataSource = cmd.ExecuteReader(); gvDetails.DataBind(); con.Close(); } } } // Save files to Folder and files path in database protected void btnUpload_Click(object sender, EventArgs e) { string filename = Path.GetFileName(fileUpload1.PostedFile.FileName); Stream str = fileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(str); Byte[] size = br.ReadBytes((int) str.Length); using (SqlConnection con=new SqlConnection(strCon)) { using (SqlCommand cmd=new SqlCommand()) { cmd.CommandText = "insert into FileInformation(FileName,FileType,FileData) values(@Name,@Type,@Data)"; cmd.Parameters.AddWithValue("@Name", filename); cmd.Parameters.AddWithValue("@Type", "application/word"); cmd.Parameters.AddWithValue("@Data", size); cmd.Connection =con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); BindGridviewData(); } } } // This button click event is used to download files from gridview protected void lnkDownload_Click(object sender, EventArgs e) { LinkButton lnkbtn = sender as LinkButton; GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow; int fileid = Convert.ToInt32(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString()); string name, type; using (SqlConnection con=new SqlConnection(strCon)) { using (SqlCommand cmd=new SqlCommand()) { cmd.CommandText = "select FileName, FileType, FileData from FileInformation where Id=@Id"; cmd.Parameters.AddWithValue("@id", fileid); cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if(dr.Read()) { Response.ContentType = dr["FileType"].ToString(); Response.AddHeader("Content-Disposition", "attachment;filename=\"" +dr["FileName"] + "\""); Response.BinaryWrite((byte[])dr["FileData"]); Response.End(); } } } } See details ... http://www.aspdotnet-suresh.com/2013/01/aspnet-download-and-upload-files-to.html

How to insert file path in text file

Answers (1)