1、对数据过滤去重(true代表使用distinct)
特别提示,这个列是返回的列,如果你datatable有什么要素最好都写上,否则就是坑
DataView dv = new DataView(Processed_data);
Processed_data = dv.ToTable(true, new string[] { "station_num", "observe_date" });
Processed_data = dv.ToTable(true, "station_num");
2、已有DataTable某列,切换数据类型的方法
#以后DataTable类型的对象,将某列字符串类型的列,改为decimal,可以添加一列对应的新列,设置类型
dtTable.Columns.Add("新名称", typeof(decimal), "要更改类型的列");
3、横向合并两个DataTable对象
说明: 此方法试用的情况是两个datatable的结构一致,而且字段排序一致,最后要实现的是关联某一字段下合并不重复字段成一个datatable
/// <summary>
/// 将两个datatble合并
/// </summary>
/// <param name="dtHead">table1</param>
/// <param name="dtTail">table2</param>
/// <param name="skipColCount">重复字段,合并时跳过</param>
/// <param name="guanLianKey">关联的字段</param>
/// <returns></returns>
private DataTable joinTwoDataTable(DataTable dtHead, DataTable dtTail, int skipColCount, string guanLianKey)
{
DataTable dtReturn = null;
if (dtHead == null)
{
dtReturn = dtTail;
}
else
{
dtReturn = dtHead.Clone();
for (int i = skipColCount; i < dtTail.Columns.Count; i++)
{
dtReturn.Columns.Add(dtTail.Columns[i].ColumnName);
}
var query =
from rHead in dtHead.AsEnumerable()
join rTail in dtTail.AsEnumerable()
on rHead.Field<string>(guanLianKey) equals rTail.Field<string>(guanLianKey)
select rHead.ItemArray.Concat(rTail.ItemArray.Skip(2));
foreach (var obj in query)
{
DataRow dr = dtReturn.NewRow();
dr.ItemArray = obj.ToArray();
dtReturn.Rows.Add(dr);
}
}
return dtReturn;
}