GridView, DataSet

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

shapper

Hello,

I have 2 SQL tables as follows:

[Articles] > ArticleId (PK), Title, Body
[Categories] > CategoryId (PK), ArticleId (FK), CategoryName

Basically I want to display a GridView with the articles.
Then for each article I want to have child gridview with the
comments.

I suppose I need to have a dataset with 2 tables, one for Articles and
other for comments.

How can I create this in ASP.NET 2.0?
And how should my SQL 2005 Stored Procedure return the data?

Thank You,
Miguel
 
You can use one dataset to hold the 2 tables and bind each table to a
gridview. Your stored procedure would have to return 2 result sets

Sam
 
Back
Top