Member Avatar for bcm

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.

  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by williamrojas78
Member Avatar for williamrojas78

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:

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

Regards

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.