Join tables in a dataset

[Bob Ross]

Is there a way to to create a single table from multiple tables in a dataset?

I currently have a dataset with multiple tables and and relations connecting those tables.
Table1 has many records to each record in Table2. I would like to create a new table which is effectively Table2 INNER JOIN Table1.
Is there an easy way to achieve this?

Or am I just going to have to manually create a new datatable and cycle through each record in Table 2 using GetParentRow to grab values from Table1 and manually build each row to populate it with?


I am using VB.Net (.Net version 2) to create a web application.

[shweta123]

Hi,

Please refer this Article

Is there a way to to create a single table from multiple tables in a dataset?

I currently have a dataset with multiple tables and and relations connecting those tables.
Table1 has many records to each record in Table2. I would like to create a new table which is effectively Table2 INNER JOIN Table1.
Is there an easy way to achieve this?

Or am I just going to have to manually create a new datatable and cycle through each record in Table 2 using GetParentRow to grab values from Table1 and manually build each row to populate it with?


I am using VB.Net (.Net version 2) to create a web application.

[Bob Ross]

Hi,

Please refer this Article

This link doesn't work for me.

[Bob Ross]

I have managed to get access to the page using a proxy website. No idea why i can't get through to it. Oh well.

Thanks very much Shweta. Thats does exactly what I want.

Just out of interest In the article it uses this syntax -
DatasetName.Tables!TableName

I have never come across this syntax before. I would always use
DatasetName.Tables("TableName")

What is the difference between the two? Where can you use the ! (exclamation mark)?

Sorry but I can't find any info through google on the syntax.

[shweta123]

Hi,

One can use both the syntax to access the tablename property.

I have managed to get access to the page using a proxy website. No idea why i can't get through to it. Oh well.

Thanks very much Shweta. Thats does exactly what I want.

Just out of interest In the article it uses this syntax -
DatasetName.Tables!TableName

I have never come across this syntax before. I would always use
DatasetName.Tables("TableName")

What is the difference between the two? Where can you use the ! (exclamation mark)?

Sorry but I can't find any info through google on the syntax.

[Bob Ross]

Okay thanks but I was looking for a little more detail than that. I managed to work that much out on my own.

I want to know - where else it can be used? What is the advantages/disadvantages? Where can I find more information on it?