將最美的計算機軟件奉獻給社會

//修改數據
    protected void EditData()
    {
        DataContext dbContext = new DataContext("data Source=192.168.0.66;database=LSS1;user id=sa;pwd=xit");
        Table<User> users = dbContext.GetTable<User>();

        var result = from user in users
                     where user.UserName == this.txtUserName.Text.Trim()
                     select user;

        foreach (User u in result)
        {
            u.Age = Convert.ToInt32(this.txtNewAge.Text.Trim().ToString());
        }

        dbContext.SubmitChanges();

    }