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