问题描述

linq to sql修改数据数据库不更新

代码执行，就是不更新
DataClasses3DataContext db = new DataClasses3DataContext();
gongzi h = new gongzi();
var results = from r in db.gongzi
where r.用户ID == Label5.Text && r.时间 == Convert.ToDateTime(Label6.Text)
select r;
if (results != null)
{
foreach (gongzi r in results)
{
r.基本工资 = Convert.ToInt32(TextBox31.Text);
r.到勤天数 = Convert.ToInt32(TextBox32.Text);
r.应到天数 = Convert.ToInt32(TextBox33.Text);
r.全勤奖 = Convert.ToInt32(TextBox34.Text);

            }
            db.SubmitChanges();
            Response.Write("<script>confirm('修改成功！');</script>");

   }