RE: Database to Data Structure

From: Saurabh Nandu (SaurabhNandu_at_discussions.microsoft.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 07:02:01 -0700

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... 

-- 
Regards,
Saurabh Nandu
AksTech Solutions, reflecting your needs...
[ www.AksTech.com ]
[ www.MasterCSharp.com ]
"Nick" wrote:
> Hi,
> 
> * I have established an ODBC connection to an interbase 5.6 .gdb file.
> * I have executed a query on the database and put the returned query
> data into a data grid.
> 
> The reason I copy the data to the grid is so that the data is
> available locally (we need the performance).
> 
> Does anybody know of anyway to load the database data directly into a
> class (or other data store) so that we don't need to use a visual
> component?  Oh, and I'd like to do it in a couple of lines.
> 
> 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).
> 
> Regards,
> 
> Nick
>

Relevant Pages

  • Re: Query to show top x% by group
    ... Next query mean you have to establish a Running Sum for the stores. ... SELECT Store, Sumas RunningTotal ...     FROM YourTable) ... I have a query that counts the number of occurrences of a given event, ...
    (microsoft.public.access.queries)
  • Re: Access combo box-show name, not ID, in table?
    ... created a record you would store that person's name. ... Now use the Combo Box Wizard to create a combo box to find a record ... Now that you have a form, you can make a query based on the form's Record ... >> what table to open etc...but provide a nice menu that opens up a nice form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Need Form and TextBox Help
    ... for that store, DM etc.... ... I am in need of advice on this one...In the ResumeDates table I was ... Then I have to think about the query I would run for the reporting ... Tracking Number - recorded in ISS table ...
    (microsoft.public.access.forms)
  • No, not exactly!
    ... at the query or report. ... The sales data is sent to us from a third party and I ... MonthName MonthNum Store #Cust $Sales Avg#Txn ... I want my report to print: ...
    (microsoft.public.access.reports)
  • subform combobox filter problem
    ... I have created a bound subform on an unbound masterform linked together ... what you see when you select a store is a list of all the ... I have created a combobox bound to a field on the ... subform's query (simple query on a single table sorting items ...
    (comp.databases.ms-access)