Error of data not submitting without uploading image

micah says:

if (FileUploadImage.HasFile)

                    {

                        string strname = FileUploadImage.FileName.ToString();

                        FileUploadImage.PostedFile.SaveAs(Server.MapPath("~/UserImage/") + strname);

             

            string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;

            string getADPOST = "Insert INTO USERPost (UserName,FriendUserName,SharedUserName,MessageStatus,Symbol,ContentPost,ImageName1) values (@UserName,NULL,NULL,NULL,NULL,@ContentPost,@ImageName1)";

            // string getADPOST = "Insert INTO CommunityFollow  (MyUserName,FriendUserName,CommunityStatus) values (@MyUserName,@FriendUserName,1)";

            using (SqlConnection con = new SqlConnection(str))

            {

                con.Open();

                using (SqlCommand cmd = new SqlCommand(getADPOST, con))

                {

 

 

                    // Get Filename from fileupload control

                    //   string filename = Path.GetFileName(FileUploadImage.PostedFile.FileName);

                    //  Save images into Images folder

                    //    Server.MapPath("~/UserImage/" + FileUploadImage.FileName);

 

                   //  cmd.Parameters.AddWithValue("@ImageName1", filename);

                    //    cmd.Parameters.AddWithValue("@ImageName1", "~/UserImage/" + filename);

                    cmd.Parameters.AddWithValue("@ContentPost", TextBixcomment.Text.Trim());

                    cmd.Parameters.AddWithValue("@UserName", username);

                    cmd.Parameters.AddWithValue("@FriendUserName", username);

                    cmd.Parameters.AddWithValue("@ImageName1", strname);

                       // con.Open();

                      //  SqlCommand cmd = new SqlCommand("insert into yourTable (FilePath) values('" + strname + "')", con);

                       // cmd.ExecuteNonQuery();

                    //     cmd.Parameters.AddWithValue("@FriendUserName", Request.QueryString["Id"].ToString());

                    //cmd.Parameters.AddWithValue("@Id", Session["Id"].ToString());

                    SqlDataAdapter da = new SqlDataAdapter(cmd);

                    DataTable ds = new DataTable();

                    da.Fill(ds);

                }

            }

        }

Change the above code with below code.

string strname = string.Empty;
if (FileUploadImage.HasFile)
{
    strname = FileUploadImage.FileName;
    FileUploadImage.PostedFile.SaveAs(Server.MapPath("~/UserImage/" + strname));
}
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string getADPOST = "Insert INTO USERPost (UserName,FriendUserName,SharedUserName,MessageStatus,Symbol,ContentPost,ImageName1) VALUES (@UserName,NULL,NULL,NULL,NULL,@ContentPost,@ImageName1)";
using (SqlConnection con = new SqlConnection(str))
{
    con.Open();
    using (SqlCommand cmd = new SqlCommand(getADPOST, con))
    {
        cmd.Parameters.AddWithValue("@ContentPost", TextBixcomment.Text.Trim());
        cmd.Parameters.AddWithValue("@UserName", username);
        cmd.Parameters.AddWithValue("@FriendUserName", username);
        cmd.Parameters.AddWithValue("@ImageName1", strname);
        cmd.ExecuteNonQuery();
    }
}