Copy from table to DataSet from dataadapter Fill() method RSS

• • Reply
  

  AlanT

  Member

  442 Points

  405 Posts

  Copy from table to DataSet from dataadapter Fill() method

  Oct 28, 2011 02:11 AM|LINK

  I have a generic method which return DataSet.

  protected DataSet ExecuteDataSet(string Query);

  Some background information, I am using third-party data provider to get data from the table and the table is encrypted.
  
  ApolloTable table = new ApolloTable();
  table.TableName = "C:\\Data\\employee.dbf";
  table.OpenMode = ApolloOpenMode.ReadWrite;
  table.Open();
  
  Can I copy data from the table to dataset without command?
  
  eg.
  
  ApolloDataAdapter da = new ApolloDataAdapter();
  ApolloConnection connection = new ApolloConnection();
  connection.Database = "C:\\Data";
  connection.Open();
  DataSet ds = new DataSet();
  da.Fill(ds, table);
  
  The reason I need to copy from table to DataSet if I need the 'table' to decrypt the table first.

  • Edited by AlanT on Oct 28, 2011 02:11 AM