linq修改数据

[zwb521]

dblinqDataContext linq = new dblinqDataContext();
var query = from s in linq.hUsers
where s.Husername == Request.Form["username"] && s.Hpassword == Request.Form["password"]
select new
{
HautoID = s.HautoID,
Hage = s.Hage.Value,
Hcity = s.Hcity
}


查询后想这么写修改数据，可是不行
foreach (var r in query)
{
r.Hage = Convert.ToInt16(Request.Form["Hage"]);
r.Hcity = Convert.ToInt16(Request.Form["Hcity"]);
}

[我姓区不姓区]

你用的是匿名类型，匿名类型中的属性是只读的不能修改
要修改的话，就另外新建一个类：

class TempClass
{
    public int HautoID {get;set;}
    public short Hage {get;set;}
    public short Hcity {get;set;}
}

dblinqDataContext linq = new dblinqDataContext();
var query = from s in linq.hUsers
where s.Husername == Request.Form["username"] && s.Hpassword == Request.Form["password"]
select new TempClass
{
HautoID = s.HautoID,
Hage = s.Hage.Value,
Hcity = s.Hcity
}

foreach (var r in query)
{
r.Hage = Convert.ToInt16(Request.Form["Hage"]);
r.Hcity = Convert.ToInt16(Request.Form["Hcity"]);
}

[zwb521]

[Quote=引用 1 楼 ojlovecd 的回复:]
你用的是匿名类型，匿名类型中的属性是只读的不能修改
要修改的话，就另外新建一个类：

C# code

class TempClass
{
public int HautoID {get;set;}
public short Hage {get;set;}
public short Hcity {get;set;}
}





dbli……
[/Quote]


23