I'm writing a function that is passed a Dataset object, performs a query on the Dataset (using the Dataset.Tables(0).Select method), manually converts
the returned array of DataRow objects to a Dataset using a loop and returns
the resulting Dataset object. I suspect somebody out there knows a simpler or
more elegant way of doing this. Any tips? Thanks!
RE: Database to Data Structure ... Why don't you use the ADO.NET DataSet object to store the data? ... Use a ODBCDataAdapter to fill a DataSet object with your query and then you can hold your data locally inside a DataSet object... ... > Hope it makes sense (I'm fairly confident, however, that there won't> be a way to this automatically - i.e. without manually extracting the> data and manually populating my own data store). ... (microsoft.public.dotnet.languages.csharp)
Should I use additional SQL Queries or use FindRows ... currently my application generates a DataSet object from a query issued to the database. ... I'm starting to wonder if it might be more efficient to use the "FindRows" method or RowFilter property on a DataView instead of issuing further queries. ... How should one determine whether it is more efficient to navigate data by issuing a SQL query for each step or whether it is more efficient to use the RowFilter property or FindRows method?... (microsoft.public.dotnet.framework.adonet)
Re: Do not get data!!!!! ... previous post re ADO not raising an exception as I am using lots of ...TADOQuery components?... try to use the dataset not the query while you are converting. ... > quirks that dont exist in the dataset object.... (borland.public.delphi.database.ado)
Re: fastest component for microsoft access ...feature rich also! ... I add records by executing Insert Query and not the dataset object where in you add a new record and then update it, ... (borland.public.delphi.thirdpartytools.general)
