[Lambda] DataTable 조건 조회 Where,FirstOrDefault

Where

string ClsCode1 = cmbClass1.GetSelectedValue("Code").Substring(0, 2);
string ClsCode2 = cmbClass1.GetSelectedValue("Code").Substring(2, 2);
var dic = new Dictionary<string, string>();
dic.Add("-", "== 선택 ==");
var lst = _dtCode.Rows.Where(c => (c["ClsCode1"].ToStringOrEmpty() == ClsCode1 && c["ClsCode2"].ToStringOrEmpty() == ClsCode2));
foreach (Silverlight.DataRow dr in lst)
    dic.Add(dr["Basecode"].ToStringOrEmpty(), dr["CodeName"].ToStringOrEmpty());

cmbClass2.SetDataSource(dic);

--------------------------------------------------------------------------------------

FirstOrDefault

조건에 맞는 데이터중 첫번째 행을 반환한다.

DataRow drFile = _ds.Tables[1].Rows.FirstOrDefault(

x =>x["FileSeq"].ToStringOrEmpty() == bo.GetValue("FileSeq")

);

DataRow dataRow = Enumerable.FirstOrDefault<DataRow>(

Enumerable.Cast<DataRow>((IEnumerable)ds.Tables[0].Rows)

);

DataRow dataRow = Enumerable.FirstOrDefault<DataRow>(

Enumerable.Cast<DataRow>((IEnumerable)ds.Tables[0].Rows)

, x => x["PartNo"].ToString().Equals(strPartNo)

);