It is updating 'locationApproval' but can't update 'locationComment', please help me for it. 'locationComment' is multiline textbox.
protected void update_Click(object sender, EventArgs e)
{
string apr;
string cm;
if (!accept.Checked)
{
apr = "Rejected";
cm = comment.Text;
}
else
{
apr = "Accepted";
cm = comment.Text;
}
if (Session["employee"] != null)
{
try
{
string td = Session["employee"].ToString();
con.Open();
cmd.Connection = con;
cmd.CommandText = "UPDATE appData SET locationApproval = '" + apr + "', locationComment = '" + cm + "' WHERE transactionId = '" + td + "';";
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception er)
{
Label1.Visible = true;
Label1.Text = er.Message;
}
}
else
{
Label1.Visible = true;
Label1.Text = "Session Error";
}
}