DataTable 轉List<T>的用法

  • 2177
  • 0

DataTable 轉List的用法

List<DataRow > RtimeList;

DataTable dt= db.ExecuteDataSet(dbCommand).Tables[0];

//資料表取得的內容

ColumnName   ColumnName1

1                            A

2                            B

3                            C

RtimeList =dt.AsEnumerable().ToList();

//從List取得欄位值

string strRTime = RtimeList.Find(dr => dr["ColumnName"].ToString() ==@Value )["ColumnName1"].ToString();