wayneph
Freshman
OK, I am finally getting around to playing with 2.0 and the new Data Web Controls that we have available. I must say it will be nice being able to do more things with out having to go into the code. However, I hit a snag.
To limit round trips to the database, I often create stored procedures that return multiple resultsets. When using a Dataset, they just get put in as multiple tables, I set a Data Relation between them and everything is happy.
Now I am trying to do something similar with a SQLDataSource. So far I have been able to set up the Select Query and populate a control with the contents of the first result, but I haven't found a way to the second table or a way to define the relation between the tables.
Has anyone done anything similar, or know of a way to work with this?
To limit round trips to the database, I often create stored procedures that return multiple resultsets. When using a Dataset, they just get put in as multiple tables, I set a Data Relation between them and everything is happy.
Now I am trying to do something similar with a SQLDataSource. So far I have been able to set up the Select Query and populate a control with the contents of the first result, but I haven't found a way to the second table or a way to define the relation between the tables.
Has anyone done anything similar, or know of a way to work with this?