Member Avatar for kindofsudden

This is probably one of those that is so simple I can't see it. I have a string variable called Market. The variable is user chosen and is the exact same name as one of many tables in my dataset. Basically I am having the user choose which table they want in a combobox, then I want to use that variable to access the table. So if the user picks "Market1" then I want to open the table named Market1.

I am simplifying here, but need to know how to open:

For ds.<variable here>.rows.count - 1
    'perform steps
Next

How do I inject the variable correctly? Thanks ahead of time!

  • 2 Contributors
  • 2 Replies
  • 193 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by kindofsudden
Member Avatar for Begginnerdev

Try This:

    Dim MyTable As String
    MyTable = "Table1"

    For i = 0 To ds.Tables(MyTable).Rows.Count - 1
        'Do Work
    Next
Member Avatar for kindofsudden

I knew it was easy. Thanks much!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.