数据库的插入总是出错！

[ttkk1024]

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();
}

[ttkk1024]

一直很纳闷啊？不知道是怎么回事啊？

[ji85907]

把shgsrs.Text与shqsl.Text分别赋给两个变量
然后把 " set shgsrs ='" + shgsrs.Text + "'" +
改为 " set shgsrs ='" + 你定义的变量 + "'" +

[ye0804]

sql语句改为:

"update dfapp2007" +
" set shgsrs ='" + shgsrs.Text + "'" +" " // 插入一串空格
" shqsl = '" + shqsl.Text + "'" ;//

你是修改两个参数的值吧,中间插入一些空格,不知对不对?

[forgot]

", shqsl = '" + shqsl.Text + "'" ;// 怎么总是在这里报错！

[jiatong1981]

报什么错误？

[王集鹄]

//
cmd.CommandText =
"update dfapp2007" +
" set shgsrs ='" + shgsrs.Text + "'" +
" shqsl = '" + shqsl.Text + "'" ;// 怎么总是在这里报错！

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

//------据我估计是少了“，”
" set shgsrs ='" + shgsrs.Text + "'," +
// ~~~

[ttkk1024]

难道他们不是一样的吗？有区别吗？

[叶子]

逻辑上就有些问题，同意楼上的。

[forgot]

你隻是漏加了逗號而已", shqsl = '" + shqsl.Text + "'" ;// 怎么总是在这里报错！

[ye0804]

还有你可以把sql语句放查询器里运行看看,检查语法

[ji85907]

"update dfapp2007 set shgsrs ='" + shgsrs.Text + "' and shqsl = '" + shqsl.Text + "'" ,第一次发的错了...

[叶子]

同意清洁工的。

[神奇的章鱼哥]

" ,shqsl = '" + shqsl.Text + "'" ;// 怎么总是在这里报错！
前面加,

[ji85907]

"update dfapp2007 set shgsrs ='" + shgsrs.Text + "' , shqsl = '" + shqsl.Text + "'" ,第一次发的错了...

[ye0804]

sql语句改为:

"update dfapp2007" +
" set shgsrs ='" + shgsrs.Text + "'" +" , "
" shqsl = '" + shqsl.Text + "'" ;//

弄错了,中间应该插入逗号,试试看