Hi,
I have a application that I would like to load a dynamic dataset based off of a array. My array is multidimensional and sets many values for my form.
example:
pWebSiteInfo(0, 1) = Home (Name of the Form)
pWebSiteInfo(1, 1) = index.aspx (File name of the web page it correlates to)
pWebSiteInfo(2, 1) = tblWebPage01 (Name of the table I want data to load my form)
Now, I have a Loop that sets a varaible (tbl) to the correct table, in this case it is tblWebPage02.
Then, I want to fill my dataset with variable tbl
The problem is that I don't know what type my variable 'tbl' should be. Right now im using string, which i know is wrong. Any thoughts? Thanks in ahead of time.
I have a application that I would like to load a dynamic dataset based off of a array. My array is multidimensional and sets many values for my form.
example:
pWebSiteInfo(0, 1) = Home (Name of the Form)
pWebSiteInfo(1, 1) = index.aspx (File name of the web page it correlates to)
pWebSiteInfo(2, 1) = tblWebPage01 (Name of the table I want data to load my form)
Now, I have a Loop that sets a varaible (tbl) to the correct table, in this case it is tblWebPage02.
VB.NET:
'Sets tbl to the name of the table
Do Until pWEBSiteInfo(0, Ctr0) = Text
Ctr0 = Ctr0 + 1
tbl = pWEBSiteInfo(2, Ctr0)
Loop
Then, I want to fill my dataset with variable tbl
VB.NET:
cDataSetTA.Connection.ConnectionString = pWEB_Server & pWEB_IntCatalog & pWEB_UserID & pWEB_Password
cDataSetTA.Fill(cDataSet.tbl)
The problem is that I don't know what type my variable 'tbl' should be. Right now im using string, which i know is wrong. Any thoughts? Thanks in ahead of time.