Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can use reflection. For example, if all of the myList_ variables are private instance variables of a class (like the Form that this even handler is defined in), then you could do something like this:</p> <pre><code>FieldInfo[] fields = MyForm.GetType().GetFields( BindingFlags.NonPublic | BindingFlags.Instance); </code></pre> <p>You'd then have to look for one with a matching name. I think there's a method to lookup a member by name, but I'm not remembering it right now. See <a href="http://msdn.microsoft.com/en-us/library/System.Type_methods.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/System.Type_methods.aspx</a> for more options.</p> <p>A more conventional approach would be to create a Dictionary that maps the name to the list object. You could populate this dictionary when the form loads then just call something like:</p> <pre><code>myFonction(dictionary["myList_" + myCombo.SelectedItem.ToString()]); </code></pre> <p>Of course, you don't have to populate the dictionary by hand: you could use reflection (like I showed above) to fill the dictionary at run-time. Then when you add a new list, you don't have to remember to add it to the dictionary. You could also use the same method to populate the combo box.</p> <p>Note: I am not suggesting that I necessarily condone what you are doing as a good design principle. That doesn't mean it can't be done. Or done well. Or be reasonable.</p> <p>EDIT: I just noticed the <strong>ref</strong> in your call (I copied and pasted your code). I can't see any reason to pass the list by reference. In any case, you can't pass it by reference if you are getting it from a dictionary -- again, why are you passing by reference?</p>
    singulars
    1. This table or related slice is empty.
    1. POPassing a variable name dynamically to a function
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJeremy West
    1. USJeremy West
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COstill can't use ref... but one could pass both the dictionary and the key, thus allowing the called method to update the stored value if needed
      singulars
      1. PO
      1. USBen Voigt
    2. CO@BenVoigt Better would be to create a local, pass *that* in by ref, and then modify the dictionary based on the result of the local after the method call.
      singulars
      1. PO
      1. USServy
    3. CO@Jeremy, rather than using `GetFields` and finding the one with the right name, just use `GetField` and pass in the name. Also, clarifying questions should be posted as comments, not in an answer to the question.
      singulars
      1. PO
      1. USServy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload