On Apr 30, 11:53 am, "Mark Rae" <m...@markNOSPAMrae.netwrote:
"shapper" <mdmo...@gmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
How can I get, from my dataset, given for example its ID, the title
and content of an article and all the titles and comments related with
that article?
http://www.google.co.uk/search?hl=en...B220GB220&q=Da...
--http://www.markrae.net
Hi,
A correction for my SQL Procedure:
SELECT a.ArticleID, a.Title, a.Content, c.CommentId, c.Title,
c.Comment
FROM Articles a
INNER JOIN Comments c ON a.ArticleID = c.ArticleID
WHERE a.ArticleDate = @articledate
Mark,
I know how to access a row of article:
Dim row As DataRow
For Each row In dataset.Tables(0).Rows
Article.ArticleId = (dataset("ArticleId")
Article.Title = (dataset("ArticleTitle")
...
Next row
My problem is how to access the comments for a given article in my
dataset.
I want to loop through each article and their comments and fell the
properties of two classes:
Article has the properties:
ArticleID, ArticleTitle, ArticleContent and Generic.List(Of Comment)
Comment has the properties:
CommentID, CommentTitle, CommentComment
I want to feel the class properties with the dataset values.
How can I do this?
Thanks,
Miguel