DataTable 的 group by 方法
- IEnumerable<IGrouping<string, DataRow>> result = dsPriceList.Tables[0].Rows.Cast<DataRow>().GroupBy<DataRow, string>(dr => dr["BP_ProviderID"].ToString());//按A分组
- foreach (IGrouping<string, DataRow> ig in result)
- {
- ig.ElementAt(j).ItemArray[1].ToString();
- DataRow newRow = null;
- newRow = tb.NewRow();
- newRow.ItemArray = row.ItemArray;
- //foreach (var dr in ig)
- //{
- // string aa = dr["BP_ProviderID"].ToString();
- // string bb = dr["S_ShortName"].ToString();
- //}
- }