Newbie: help with datareader

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: steve (noemail._at_try.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 16:07:57 -0400

Hello,
I have the follwing "decision-making" problem:

- I want to construct an interface with a few radios, listboxes etc so that
a user can, by selecting some or all of them, dynamically create an SQL
string. This is fine, and i have an example to consult.

- *After* the string is constructed what is the best way (SIMPLEST) to
*display AND store* the data? Datareader or Dataset?

-->>>My biggest problem is that I dont know at design time the number of
fields that will be returned from the query !!!
It depends on the user's selections.
So I *cannot* decide beforehand the number of columns on a multicolumn
ListView or listbox etc. that will be needed to display the result.

Remember that I need to store the result as well, for further processing
(statistics,etc.) so should i use an array for that?

Any suggestions / links would be appreciated !
TIA
-steve

Relevant Pages

  • Re: Problem: combobox, table lookup, adding new record
    ... My form prompts for the date, then the store where I purchased ... After selecting the store, my next field will display criteria ... >in an item not in the combobox list, and have it be added to the "short ...
    (microsoft.public.access.forms)
  • Newbie: help with datareader
    ... - I want to construct an interface with a few radios, listboxes etc so that ... a user can, by selecting some or all of them, dynamically create an SQL ... ListView or listbox etc. that will be needed to display the result. ... Remember that I need to store the result as well, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: LINKING FIELDS
    ... >selecting the table, a combo box is then populated with two fields from the ... >I then need to display the rest of the fields in another type of object ... AfterUpdate event procedure: ... The complete solution also depends on where do you store the ...
    (microsoft.public.access.formscoding)
  • Re: Imminent alpha release of Portal Builder for Delphi
    ... what browser are you using? ... >>>display inside the IFRAME. ... on "fabrics" page, after selecting any fabric tab, the selected ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How does autofilled form fields info end up in table fields?
    ... related dated, however, doesn't "cascade" into any of the tables. ... click on the Display Control tab. ... >> query and used form wizard, selecting various fields and tables and had a ... I even tried datasheet style form, ...
    (microsoft.public.access.formscoding)