Hi Guys
Fairly new to using this so stay with me !
I'm using a dataset with table adapters to retrieve information from a database.
I'm using a value I retrieved from one table to retrieve some more values in another table.. I then want to insert the values retrieved into another table....
For example I retrieve Birmingham from Table1 and I want to use this variable to retrieve all of the football teams from stoke that reside in another table.
How can I do this?
My table adaptor has a query -
I then dim the table adaptor and i've tried to assign it to a data table, e.g -
Any help?
I'm used to iterating through the select statement with a loop - table adaptors are confusing me
Fairly new to using this so stay with me !
I'm using a dataset with table adapters to retrieve information from a database.
I'm using a value I retrieved from one table to retrieve some more values in another table.. I then want to insert the values retrieved into another table....
For example I retrieve Birmingham from Table1 and I want to use this variable to retrieve all of the football teams from stoke that reside in another table.
How can I do this?
My table adaptor has a query -
Code:
Select teamName from teams where location = @???I then dim the table adaptor and i've tried to assign it to a data table, e.g -
Code:
DIM teamData as Data.DataTable
DIM footyTeamsAdapter as new football_tableadaptors.TeamAdaptor
teamData = footyTeamsAdapter.ReturnTeams(location var)Any help?
I'm used to iterating through the select statement with a loop - table adaptors are confusing me