datatable常用方法

1、取datatable中符合条件的行

DataView dv = new DataView(dtCurrVouchs);dv.RowFilter = "订单编号='" + cPOID + "'";dtCurrVouch = dv.ToTable();

2、取datatable中符合条件的列

DataView dv = new DataView(dt);string[] strComuns ={ "订单编号", "订单日期", "采购类型", "供应商简称","币种","付款条件","制单人" };dtHead = dv.ToTable(false, strComuns);

3、去除datatable中重复的行

dtHead = dv.ToTable(true, strComuns);