如何将table1中第x到第y行的数据复制到另一个table2中

[leeajax]

OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,x,y-x,"book");
我想吧这一步分成亮步

1.MyAdapter.Fill(ds,"book");
2.在怎么办？

[CMIC]

DataTable table1=new DataTable();
DataTable table2=new DataTable();
//..........
for (int i=x;i<y;i++)
{
table2.ImportRow(table1.Rows[i]);
}

[smoothwood]

Dim conn As New SqlConnection("Server=localhost;user id=sa;password=xxx;database=Northwind;")
Dim da As New SqlDataAdapter("Select * from products", conn)
Dim ds As New DataSet
da.Fill(ds, "Products")
Dim ds1 As New DataSet
Dim datTable As New DataTable
Dim datRow As DataRow
Dim ary() As Object
datTable = ds.Tables("Products").Clone()
For iCount As Integer = 0 To 2
datRow = datTable.NewRow
ary = ds.Tables("Products").Rows(iCount).ItemArray()
datRow.ItemArray = ary
datTable.Rows.Add(datRow)
Next
ds1.Tables.Add(datTable)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
DataGrid2.DataSource = ds1
DataGrid2.DataBind()

[liuyu202]

楼上的办法好，学习！

[为防老年痴呆而编程]

学习

[cooleader123]

支持smoothwood(I try my best)