C#中获取DataTable中的某一列数据,存入List<T>
Field 需要用到System.Data.DataSetExtensions
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace ConsoleApplication108
{
class Program
{
static void Main(string[] args)
{
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Qty", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add(new object[] { 0, 321, 33 });
dt.Rows.Add(new object[] { 1, 100, 4 });
dt.Rows.Add(new object[] { 2, 355, 23 });
List<int> results = dt.AsEnumerable().Select(x => x.Field<int>("Qty")).ToList();
foreach(var i in results)
{
Console.WriteLine(i);
}
Console.ReadK