VB.NET

VB.NET RSS

changing part of URL PATH

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2007

Posts: 63

Reputation: bcm is an unknown quantity at this point

Solved Threads: 0

bcm

Offline

Junior Poster in Training

changing part of URL PATH

Sep 14th, 2007

I am doing a project where I am retriving data from a table minicard of a site.
I am using path http://www.cric8.com/od_minicard2.htm
The table has a number od_minicard2_1355
The problem is that when there are two table it pull data of only one table.
how can I get data of both tables say od_minicard2_1355 & od_minicard2_1356
The name of table always increases by one 1355,13356,1357,etc.

BCM

•

Join Date: Jun 2005

Posts: 85

Reputation: williamrojas78 is an unknown quantity at this point

Solved Threads: 4

williamrojas78 williamrojas78 is offline

Offline

Junior Poster in Training

Re: changing part of URL PATH

Sep 14th, 2007

Hi

You probably will have to find the number of tables in the dataset, and then go into a loop to retrieve the data. If the tables always start with the "od_minicard2_xxxx" then it is probably a good idea to check the name of the table to make sure you are reding the correct data.

Somthing like this:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
 Dim i As Integer
 Dim iNumTables As Integer = dstVeh.Tables.Count
 
 For i = 0 To iNumTables - 1
     Dim strTableName As String = dstVeh.Tables(i).TableName
 
 ' here you have the table name, so now compare it to "od_minicard2_..."
 ' to make sure it is the right table.
 
  'if it is the right table, then get the data from dstVeh.Tables(i)
 
 Next
 Dim i As Integer
 Dim iNumTables As Integer = dstVeh.Tables.Count

 For i = 0 To iNumTables - 1
     Dim strTableName As String = dstVeh.Tables(i).TableName

 ' here you have the table name, so now compare it to "od_minicard2_..."
 ' to make sure it is the right table.

  'if it is the right table, then get the data from dstVeh.Tables(i)

 Next