unexpected behaviour while filling a DataTable from a recordset

hi,
I've just encountered a problem while filling a DataTable from recordset using the OleDBDataAdapter.fill method.Once a table is filled ,no more tables can be filled by the same method and same recordset.
The recordset is intact and I can get the data by its methods,but the fill method returns no rows in the next calls.
nothing seems to be wrong ,and this behaviour is very odd.
can any body tell what's going wrong in here.
I added  a reference in my solution to the adodb PIA in .net pane of references(I test all of the versions and get the sanme results).
here is the code I used to test these with:




                  ADODB.Connection cn=new ADODB.ConnectionClass();
                  cn.ConnectionString="provider=sqloledb;server=HOME;database=northwind;uid=sa";
                  cn.Open(cn.ConnectionString,"sa","123",0);
                  ADODB.Recordset rs=new ADODB.RecordsetClass();
                  rs.CursorLocation=ADODB.CursorLocationEnum.adUseClientBatch;
                  rs.CursorType=ADODB.CursorTypeEnum.adOpenStatic;
                  rs.LockType=ADODB.LockTypeEnum.adLockOptimistic;
                  rs.Open("Select * from products",cn,rs.CursorType,rs.LockType,0);
                  rs.ActiveConnection=null;
                  cn.Close();
                  OleDbDataAdapter da=new OleDbDataAdapter();
                  DataTable dt=new DataTable("products");
            DataSet ds=new DataSet();
                  da.Fill(dt,rs);
                  ds.Tables.Add(dt);
                  Console.WriteLine("there are{0}rows",ds.Tables["products"].Rows.Count);
                  DataTable dt2=new DataTable();
                  DataSet ds2=new DataSet();
                  da.Fill(dt2,rs);                        //<--no rows is added to the table
                  ds2.Tables.Add(dt2);
                  Console.WriteLine("there are{0}rows",ds2.Tables[0].Rows.Count);Start Free Trial