Biegral Blog

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(); //} }