When i run the code below with stored proc :-
I get only the first table results :-"templates"
even if i fill the dataset with another table for example
category,pages etc..
Any ideas?
Store procedure below:-
------------------------
ALTER PROCEDURE dbo.webpage
AS
Select template_id,template_header,template_footer from templates
Select link_id,link_text,link_url from links
Select category_id,category_text,category_url from category
Select page_id,page_category,page_title,page_subtitle,pag e_text from
pages
RETURN
GO
Dim TreetableDataSet As DataSet
Dim TreetableConnection As SqlConnection
Dim TreetableAdapter As SqlDataAdapter
'Dim cmdcommand As SqlCommand
TreetableConnection = New
SqlConnection("server=(local);database=northwind;i ntegrated
security=true;")
TreetableAdapter = New SqlDataAdapter("webpage",
TreetableConnection)
TreetableDataSet = New DataSet
Try
TreetableConnection.Open()
TreetableAdapter.Fill(TreetableDataSet, "links")
TreetableDataGrid.DataSource = TreetableDataSet
TreetableDataGrid.DataMember = "links"
TreetableDataGrid.DataBind()
Catch TreetableException As SqlException
'TreetableExceptionLabel.Text = TreetableException.Message
Finally
TreetableConnection.Close()
End Try
*** Sent via Developersdex http://www.developersdex.com ***