/// <summary> /// 用linq取回年份(TWYear) /// </summary> private int GetYear(DataSet ds, string strPeriodID) { DataTable Periods = ds.Tables[0]; EnumerableRowCollection <DataRow> query = from Period in Periods.AsEnumerable() where Period.Field <int>("Period") == Convert.ToInt32(strPeriodID) select Period; IEnumerable <DataRow> rows = from row in query select row; int intYear = 0; foreach (DataRow row in rows) { //取得資料 intYear = Convert.ToInt32(row["PeriodYear"].ToString()); } return(intYear); }