fileupload control

Question

hi
by using this code
static string impath = string.Empty;

PhotoUpload.SaveAs(Server.MapPath("~/Logos/" + PhotoUpload.FileName));

impath = "~/Logos/" + PhotoUpload.FileName;

ImagePreview.ImageUrl = impath;

btnPhotoPreview.Visible = false;
the filename should be empty why?
please help me

Santhosh Kumar Jayaraman · Answer

you meant PhotoUpload.FileName is empty? Please check whether photupload has file before doing this if ( PhotoUpload .HasFile) { static string impath = string.Empty; PhotoUpload.SaveAs(Server.MapPath("~/Logos/" + PhotoUpload.FileName)); impath = "~/Logos/" + PhotoUpload.FileName; ImagePreview.ImageUrl = impath; btnPhotoPreview.Visible = false; }

Santhosh Kumar Jayaraman · Answer

Try something like this after this line. string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); string strQuery = "insert into Photos (FileName, FilePath)" + " values(@FileName, @FilePath)"; SqlCommand cmd = new SqlCommand(strQuery); cmd.Parameters.AddWithValue("@FileName", FileName); cmd.Parameters.AddWithValue("@FilePath", impath); cmd.CommandType = CommandType.Text; cmd.Connection = con; try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { Response.Write(ex.Message); } finally { con.Close(); con.Dispose(); }

prathyusha · Answer

actually i use only fileupload control by using this i can save the path in sql please help me

fileupload control

Answers (3)