DataTable dt = new DataTable();
dt.Columns.Add("xx_Name", System.Type.GetType("System.String"));
dt.Columns.Add("xx_NO", System.Type.GetType("System.String"));
dt.Rows.Add("A", "kx-507");
dt.Rows.Add("A", "kx-507");
dt.Rows.Add("A", "kx-507");
dt.Rows.Add("B", "kx-825");
///方法一:更简洁//
Console.WriteLine(dt.Rows.OfType<DataRow>().First(x => x.Field<string>("xx_Name") == "A").Field<string>("xx_NO"));
//方法二:linq 更清晰/
var query = from dr in dt.AsEnumerable()
where dr.Field<string>("xx_Name") == "A"
select dr;
Console.WriteLine(query.First().Field<string>("xx_NO"));
转自:http://bbs.csdn.net/topics/390838620