分解数据表(将一个datatable按数据量分隔成多个table)

/// <summary>
/// 分解数据表
/// </summary>
/// <param name="originalTab">需要分解的表</param>
/// <param name="rowsNum">每个表包含的数据量</param>
/// <returns></returns>
public DataSet SplitDataTable(DataTable originalTab, int rowsNum)
{
//获取所需创建的表数量
if (rowsNum==0) {
rowsNum = 1;
}
int tableNum = originalTab.Rows.Count / rowsNum;

//获取数据余数
int remainder = originalTab.Rows.Count % rowsNum;

DataSet ds = new DataSet();

//如果只需要创建1个表,直接将原始表存入DataSet
if (tableNum == 0)
{
if (originalTab.Rows.Count==0) {
ds.Tables.Add(new DataTable());
}
else
{
ds.Tables.Add(originalTab);
}
}
else
{
DataTable[] tableSlice = new DataTable[tableNum];

//Save orginal columns into new table.
for (int c = 0; c < tableNum; c++)
{
tableSlice[c] = new DataTable();
foreach (DataColumn dc in originalTab.Columns)
{
tableSlice[c].Columns.Add(dc.ColumnName, dc.DataType);
}
}
//Import Rows
for (int i = 0; i < tableNum; i++)
{
// if the current table is not the last one
if (i != tableNum - 1)
{
for (int j = i * rowsNum; j < ((i + 1) * rowsNum); j++)
{
tableSlice[i].ImportRow(originalTab.Rows[j]);
}
}
else
{
for (int k = i * rowsNum; k < ((i + 1) * rowsNum + remainder); k++)
{
tableSlice[i].ImportRow(originalTab.Rows[k]);
}
}
}

//add all tables into a dataset
foreach (DataTable dt in tableSlice)
{
ds.Tables.Add(dt);
}
}
return ds;
}

上一篇:Effective Java设定游戏 - 就是爱Java


下一篇:C/C++获取Linux系统CPU和内存及硬盘使用情况