数据库的插入总是出错！

SqlConnection sqlConnection1 =
new SqlConnection( "Data Source=YJY3;Initial Catalog=dflicapp;Integrated Security=True ");

try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText =
"update dfapp2007 " +
" set shgsrs = ' " + shgsrs.Text + " ' " +
" shqsl = ' " + shqsl.Text + " ' " ;// 怎么总是在这里报错！

cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
result2.Visible = true;
}
catch (SqlException ex)
{
Response.Write(ex.Number);
Response.Write(ex.Message);
Response.Write(ex.StackTrace);
}
finally
{
sqlConnection1.Close();
}

[解决办法]
", shqsl = ' " + shqsl.Text + " ' " ;// 怎么总是在这里报错！
[解决办法]
//
cmd.CommandText =
"update dfapp2007 " +
" set shgsrs = ' " + shgsrs.Text + " ' " +
" shqsl = ' " + shqsl.Text + " ' " ;// 怎么总是在这里报错！

Console.WriteLine(cmd.CommandText); //先输出到查询分析器里测试看看

//------据我估计是少了“，”
" set shgsrs = ' " + shgsrs.Text + " ', " +
// ~~~
[解决办法]
" ,shqsl = ' " + shqsl.Text + " ' " ;// 怎么总是在这里报错！
前面加,