Easiest way to query Dataset and return a Dataset
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!
-Jerry
.
Relevant Pages
- 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) |
|