wayneph Posted November 11, 2005 Posted November 11, 2005 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? Quote wayne The Road Goes on Forever and the Party Never Ends - Robert Earl Keen
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.