linq 方便我们处理数据你对他了解多少呢？
今天了解了下Linq
DataClassesDataContext data = new DataClassesDataContext();
var tasks = from t in data.ttt
orderby t.a descending
select new { test1 = t.a, test2 = t.b, 测试3 = t.ttt1 }; //显示所有 并改变列名
//var tasks = from t in data.ttt
// orderby t.a descending
// select t; //显示所有
//var tasks = from t in data.ttt where t.a==1
// orderby t.a descending
// select t; //显示符合条件的
GridView1.DataSource = tasks.ToList();
GridView1.DataBind();
var tasks1 = from t in data.ttt where t.a == 1 select t;
foreach (ttt match in tasks1) //修改
match.a = 123123;
data.SubmitChanges();
ttt tt = new ttt();
tt.a = 1001;
tt.b = "test";
tt.ttt1 = 123;
data.ttt.InsertOnSubmit(tt); //添加
data.SubmitChanges();
var tasks2 = from t in data.ttt where t.a == 1 select t;
data.ttt.DeleteAllOnSubmit(tasks2); //删除查到的记录
data.SubmitChanges();
详见：http://www.itclw.net/forum.php?mod=viewthread&tid=98&extra=page%3D1
