Your problem is while the user doesn't choose a image,
yours code is
if (fileUpload != null && fileUpload.HasFile)
{
if (fileUpload.PostedFile.ContentType.ToLower().StartsWith("image/"))
{
fileUpload.SaveAs(Server.MapPath("~/images/users/" + fileUpload.FileName));
}
else
{
// Not an image, handle accordingly
}
}
hence the user must select an image to execute on the above condition.
the the else in the if (fileUpload != null && fileUpload.HasFile) is totally useless.
Simply U can understand mean u need two query one is for with image another for without image .the query u written only execute when the user select an image..
small key
if(fileupload.HasFile)
{
query with image update
}
else
{
query without image update
}
if (Session["UsrNme"] != null)
{
string EditUsrInfoSQL = @"Update UserInfo SET FN=@FN, LN=@LN, Password=@Password, RePass=@RePass, Website=@Website, Post=@Post, Email=@Email,
Address=@Address, TeleNum=@TeleNum, Facebook=@Facebook, GooglePlus=@GooglePlus, Twitter=@Twitter, Img=@img Where UID=@UID";
string EditUsrInfoSQLWithoutImage = @"Update UserInfo SET FN=@FN, LN=@LN, Password=@Password, RePass=@RePass, Website=@Website, Post=@Post, Email=@Email,
Address=@Address, TeleNum=@TeleNum, Facebook=@Facebook, GooglePlus=@GooglePlus, Twitter=@Twitter Where UID=@UID";
EditUsrInfocmd.Connection = EduSRiNFOCon;
EditUsrInfocmd.CommandType = CommandType.Text;
EditUsrInfocmd.CommandText = EditUsrInfoSQL;
EditUsrInfocmd.Parameters.AddWithValue("@UID", ((Label)EditUsrInfoFVw.FindControl("UIDEDLabel")).Text);
EditUsrInfocmd.Parameters.AddWithValue("@TeleNum", ((TextBox)EditUsrInfoFVw.FindControl("TeleEDTTXTBX")).Text);
EditUsrInfocmd.Parameters.AddWithValue("@Facebook", ((TextBox)EditUsrInfoFVw.FindControl("FaceEDTTXTBX")).Text);
EditUsrInfocmd.Parameters.AddWithValue("@GooglePlus", ((TextBox)EditUsrInfoFVw.FindControl("GoogEDTTXTBX")).Text);
EditUsrInfocmd.Parameters.AddWithValue("@Twitter", ((TextBox)EditUsrInfoFVw.FindControl("TwitEDTTXTBX")).Text);
EditUsrInfocmd.Parameters.AddWithValue("@img", ((FileUpload)EditUsrInfoFVw.FindControl("EditImgFUP")).FileName);
var fileUpload = EditUsrInfoFVw.FindControl("EditImgFUP") as FileUpload;
if (fileUpload != null && fileUpload.HasFile)
{
fileUpload.SaveAs(Server.MapPath("~/images/users/" + fileUpload.FileName));
EduSRiNFOCon.Open();
int result = EditUsrInfocmd.ExecuteNonQuery();
if (result > 0)
{
}
}
else
{
EduSRiNFOCon.Open();
int result = EditUsrInfoSQLWithoutImage.ExecuteNonQuery();
if (result > 0)
{
}
}
}
}
ReHPPersInfo();
}