Creating a dataset from multiple tables

[cusoxty]

I am trying to create a dataset using data from multiple tables. however, it does not seem to let me move on to this second table. Here is the code i currently have. Can anyone offer me help as to what direction I should go in to fix my problems?

Sub Page_Load(sender As Object, e As EventArgs)

dim DtaSetTransfers As Dataset
dim accounttransfers As SqlDataAdapter



DtaSetTransfers = New DataSet()
dim conn as New SQLConnection(connstr)
conn.Open()
accounttransfers = New SqlDataAdapter ("Select AccountName From Accounts",conn)
accounttransfers.Fill (DtaSettransfers, "AccountName")
accounttransfers.SelectCommand = New SqlCommand ("Select TerritoryName From Territories",conn)
accounttransfers.Fill (DtaSettransfers, "TerritoryName")

transfers.DataSource = DtaSettransfers
transfers.DataBind()
conn.Close()

------------------ Heres my datagride-----------------
<asp:DataGrid id="transfers" runat="server">
<HeaderStyle font-bold="True"></HeaderStyle>
</asp:DataGrid>

[PeOfEo]

grid.datasource=dataset.tables("table").defaultview
use .tables to distinguish between the two tables for the grid. You can't have a data grid displayingdata from two separate data sets. You can go back and do this all manually though with a loop and response.write out data from two separate places at one time. I prefer to keep my stuff one table per data set so I do not get mixed up though. But just try using .tables when you set a data source.

[roteague]

You could also try doing a union between the two tables. That way you wouldn't have to worry about doing two tables.

[PeOfEo]

Originally posted by roteague
You could also try doing a union between the two tables. That way you wouldn't have to worry about doing two tables. or just using separate data sets too.
edit: woops, posted something to that extent already... sometimes I forget what I post.

[ravisankar]

try this

transfers.DataMember= <TableName>
trnsfer.DataBind()

[CardboardHammer]

It isn't clear exactly what you're trying to accomplish from your OP. If what you want is a list of accounts with their territories, do a join between the two tables:

SELECT Accounts.AccountName, Territories.TerritoryName
FROM Accounts INNER JOIN Territories
ON Accounts.[Foreign Key from Territories] = Territories.[Primary Key]

[robertsams23]

try these links

http://vb.net-informations.com/dataset/vb.net-ado.net-dataset-tutorial.htm

http://vb.net-informations.com/dataset/dataset-multiple-tables-sqlserver.htm

lemo