Dataset - Get Values

  • Thread starter Thread starter shapper
  • Start date Start date
S

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
 
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 said:
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
Click to expand...
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?
Click to expand...
The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...
Click to expand...
Thanks,
Miguel
Click to expand...
Click to expand...

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
 
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.





shapper said:
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 said:
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
Click to expand...
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?
Click to expand...
The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...
Click to expand...
Thanks,
Miguel
Click to expand...
Click to expand...

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
Click to expand...
 
Back
Top