Solved

Programmatically change a variable Name

Posted on 2010-09-16
6
523 Views
Last Modified: 2012-05-10

Here is what I'm trying to do.

I have a list of tags in an array downloaded from another source.  I wish to take this array of items and put them in a data table.  This data table will be saved as an ACCESS database.

The brute force method which works is given below.

I would just go with that other than the tag array is not always the same size which means more coding.   It seems there should be a way to  add the # to tag# at the end of each currentrow in some type of code.   Easy to do if its a string or array, but not a specific row object linked to a row in a database.  Ideas to solve this ?


For I = 0 To listReturn.Count - 1
   Dim currentrow As EtsyDataSet.EtsyListingRow = Etsydata.EtsyListing.NewEtsyListingRow

 currentrow.tag1 = listReturn(I).tags(1).ToString
 currentrow.tag2 = listReturn(I).tags(2).ToString
 currentrow.tag3 = listReturn(I).tags(3).ToString
 currentrow.tag4 = listReturn(I).tags(4).ToString
 currentrow.tag5 = listReturn(I).tags(5).ToString
 currentrow.tag6 = listReturn(I).tags(6).ToString
  currentrow.tag12 = listReturn(I).tags(12).ToString

 Etsydata.EtsyListing.AddEtsyListingRow(currentrow)

Open in new window

0
Comment
Question by:Zimbug4
  • 2
  • 2
  • 2
6 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 33697954
Im not familiar with EtsyDataSet but taking a educated guess

does the listing row show something like Field or Itrem?

eg

currentrow.Item("tag1")

would the above work?
if so then maybe a count like this

for i in 1 to 6
    currentrow.Item("tag" & i) = listReturn(I).tags(i).tostring


see if there is any property like that
0
 
LVL 9

Expert Comment

by:rfportilla
ID: 33697957
0
 
LVL 9

Expert Comment

by:rfportilla
ID: 33697987
I think Rockiroads has the right idea.   It depends on what the object will support, but you can create "dynamic" variable names in an associative array using strings.  I think this is what you are looking for...
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:Zimbug4
ID: 33709630
Rockiroads educated guess was correct.  The use of item worked.
I've added below what worked based on the suggestion
For Each item In listReturn(I).tags
    cnt = cnt + 1
    currentrow.Item("tag" & cnt.ToString) = listReturn(I).tags(cnt - 1).ToString
   Next

Open in new window

0
 

Author Closing Comment

by:Zimbug4
ID: 33709633
Thanks!  I knew there had to a lot easier way than the way what I was approaching it.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33710106
Cool. Nice educated guess then :)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.NET Repostiory Pattern 7 51
I need help converting a bitmap to an image in VB.Net 1 43
Crystal reports vb.net 2 54
Help with opening combobox using VB.NET. 3 25
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question