|M| 如何将DataTable时面的前100条记录存到更一个DataTable 谢谢
谢谢

------解决方案--------------------
DataTable dtNew = dt.Clone();
for( int i=0; i <100; i++ )
{
DataRow newRow = dtNew.NewRow();
newRow.ItemArray = dt.Rows[i].ItemArray;
dtNew.Rows.Add( newRow );
}
------解决方案--------------------
jf
------解决方案--------------------
DataTable dt1 = new DataTable();
dt1.Columns.Add( "year ", typeof(int));
dt1.Columns.Add( "month ", typeof(int));
dt1.Columns.Add( "total ", typeof(int));
for (int ix = 0; ix < 120; ix++)
{
dt1.Rows.Add(new object[] { 2007, 1, ix });
}

DataTable dt3 = dt1.Clone();
Response.Write(dt3.Rows.Count);
for (int i = 0; i < 100; i++)
{
DataRow newRow = dt3.NewRow();
newRow.ItemArray = dt1.Rows[i].ItemArray;
dt3.Rows.Add(newRow);
}
Response.Write( " <br /> ");
Response.Write(dt3.Rows.Count);
------解决方案--------------------
只能通过循环一条条的导入了,上面的都可以,不过可以简化一下吧:

DataTable dtNew = dt.Clone();
for( int i=0; i <100; i++ )
{
dtNew.Rows.Add( dt.Rows[i].ItemArray);
}