Hi micah,
C#
private void InsertDatabase(string userName, string fuserName, string contentPost, DateTime sendDate, string modelId, string comment)
{
using (SqlConnection con = new SqlConnection(constrr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO USERPost VALUES(@UserName,@FriendUserName,@ContentPost,,@ImageName1,@SendDate,@ShareId,@Comments,@FriendImageName,@null,@null)", con))
{
// cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@UserName", username = this.Page.User.Identity.Name);
cmd.Parameters.AddWithValue("@FriendUserName", fuserName);
cmd.Parameters.AddWithValue("@ContentPost", contentPost);
cmd.Parameters.AddWithValue("@SendDate", sendDate);
cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@Comments", comment);
cmd.Parameters.AddWithValue("@FriendImageName", img2);
cmd.Parameters.AddWithValue("@TotalCount", );
cmd.Parameters.AddWithValue("@ADStatus", );
cmd.Parameters.AddWithValue("@ImageName1", umg);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Replace above code with below.
private void InsertDatabase(string userName, string fuserName, string contentPost, DateTime sendDate, string modelId, string comment)
{
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO USERPost VALUES(@UserName,@FriendUserName,@ContentPost,@ImageName1,@SendDate,@ShareId,@Comments,@FriendImageName)", con))
{
// cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@UserName", username = this.Page.User.Identity.Name);
cmd.Parameters.AddWithValue("@FriendUserName", fuserName);
cmd.Parameters.AddWithValue("@ContentPost", contentPost);
cmd.Parameters.AddWithValue("@ImageName1", umg);
cmd.Parameters.AddWithValue("@SendDate", sendDate);
cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@Comments", comment);
cmd.Parameters.AddWithValue("@FriendImageName", img2);
cmd.Parameters.AddWithValue("@TotalCount", DBNull.Value);
cmd.Parameters.AddWithValue("@ADStatus", DBNull.Value);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}