Dataset - Get Values

[shapper]

Hello,
I have an SQL Stored Procedure that uses Inner Join to return the
records of various related tables:
SELECT * FROM dbo.by27_Blogger_Posts p
LEFT JOIN (
SELECT *
FROM dbo.by27_Blogger_Comments c
LEFT JOIN dbo.by27_Membership_Users u
ON c.AuthorId = u.UserId) AS cu
ON p.PostId = cu.PostId
....
WHEREp.PostId = @PostId
ORDER BY p.PostUpdatedDate

Now I get a dataset with all this data.
How can I, for example, loop through each PostId? And for each PostId
loop through each CommentId associated to it? And of course access the
columns?

The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...

Thanks,
Miguel

 

[Chris Fulstow]

Hi Miguel,

Maybe check out Scott Guthrie's ASP.NET data access tutorials, the
sections about Typed DataSets and TableAdapters might be useful to
you.

http://www.asp.net/learn/data-access/#advanced

Chris

 

[Guest]

The SQL Statement you show will return a single resultset. So the DataSet you
get back from this will have a single DataTable with all the columns.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

 

[shapper]

The SQL Statement you show will return a single resultset. So the DataSet you
get back from this will have a single DataTable with all the columns.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

Hello,
I have an SQL Stored Procedure that uses Inner Join to return the
records of various related tables:
SELECT * FROM dbo.by27_Blogger_Posts p
LEFT JOIN (
SELECT *
FROM dbo.by27_Blogger_Comments c
LEFT JOIN dbo.by27_Membership_Users u
ON c.AuthorId = u.UserId) AS cu
ON p.PostId = cu.PostId
....
WHEREp.PostId = @PostId
ORDER BY p.PostUpdatedDate

Now I get a dataset with all this data.
How can I, for example, loop through each PostId? And for each PostId
loop through each CommentId associated to it? And of course access the
columns?

The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...

Thanks,
Miguel

Peter,

I know but the question is:
Is it possible to create the loop I mentioned or should I use various
SELECTs to return various tables?

Thanks,
Miguel

 

[sloan]

I already responded to this yesterday.

My suggestion was to have 2 resultsets (2 select statements) coming back,
and process those.

I gave a link to a complete working example.

.....

Do you have a weak (untyped) or strong (typed) dataset you're dealing with?

...

Check my blog (again) and find the 1.1 version of the example I gave you
"Custom Objects in 1.1" or something like that.
I have extra dataset code there.

The SQL Statement you show will return a single resultset. So the DataSet
you
get back from this will have a single DataTable with all the columns.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

Hello,
I have an SQL Stored Procedure that uses Inner Join to return the
records of various related tables:
SELECT * FROM dbo.by27_Blogger_Posts p
LEFT JOIN (
SELECT *
FROM dbo.by27_Blogger_Comments c
LEFT JOIN dbo.by27_Membership_Users u
ON c.AuthorId = u.UserId) AS cu
ON p.PostId = cu.PostId
....
WHEREp.PostId = @PostId
ORDER BY p.PostUpdatedDate

Now I get a dataset with all this data.
How can I, for example, loop through each PostId? And for each PostId
loop through each CommentId associated to it? And of course access the
columns?

The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...

Thanks,
Miguel

Peter,

I know but the question is:
Is it possible to create the loop I mentioned or should I use various
SELECTs to return various tables?

Thanks,
Miguel