Troubleshooting C# SQL insert

Up until a few hours ago, this code and similar code worked fine. I dropped and recreated the database to change the timestamp datatype so it would show as the time the record was updated. That is fine now, I've used current_timestamp to fix it.

current_timestamp

That was the ONLY change I made to the database, otherwise it's the same server, same database name, same connection string in VS2017. I even changed servers a few days ago and nothing went wrong but for some reason this code hasn't worked since I dropped it.

Can anyone suggest why? Was the code just originally flawed?

protected void BtnSubmitPost_ServerClick(object sender, EventArgs e)
{
string bpTitle = txtBlogHeader.Text;
string bpBody = txtBlogBody.Text;

using (SqlConnection addBlogConn = new SqlConnection(ConfigurationManager.ConnectionStrings["childrens"].ConnectionString))
{
using (SqlCommand addBlogCmd = new SqlCommand())
{
try
{
addBlogCmd.CommandType = CommandType.Text;
addBlogCmd.CommandText = "INSERT INTO blogPosts (bp_header, bp_body) VALUES (@bpTitle, @bpBody)";

addBlogCmd.Parameters.Add("@bpTitle", SqlDbType.VarChar).Value = bpTitle;
addBlogCmd.Parameters.Add("@bpBody", SqlDbType.VarChar).Value = bpBody;
addBlogCmd.Connection = addBlogConn;

addBlogConn.Open();
lblBhError.Visible = false;
//lblStaffConfirm.Visible = true;
lvBlogs.DataBind();
addBlogConn.Close();
}
catch
{
Response.Redirect("/staff.aspx");
}
}
}
}


1 Answer
1

Well I don't see you are executing the command addBlogCmd at all since there is nothing after addBlogConn.Open(); statement. Moreover, neither I see you are using disconnected architecture by means of dataadapter/dataset. So probably that explains the problem.

addBlogCmd

addBlogConn.Open();

Essentially you are missing addBlogCmd.ExecuteNonQuery() statement to execute the command you have prepared

addBlogCmd.ExecuteNonQuery()

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.