LINQ按数字值排序DataTable
原创
©著作权归作者所有:来自51CTO博客作者wx5aab5af48c1c4的原创作品,请联系作者获取转载授权,否则将追究法律责任
LINQ按数字值排序DataTable
var result = from item in dtCopy.Select()
orderby int.Parse(item[selcol].ToString()) ascending
select item;
DataTable dt = new DataTable();
//创建列
foreach (DataColumn item in dtCopy.Columns)
dt.Columns.Add(item.ColumnName);
//添加行
foreach (DataRow item in result)
{
DataRow drNew = dt.NewRow();
for (int i = 0; i < item.Table.Columns.Count; i++)
drNew[i] = item[i];
dt.Rows.Add(drNew);
}
dataGridView1.DataSource = dt;