As read the thread from beginning to end, I found it humorous and
frustrating.
But I have the same question as Dick and have been searching for answers
in the last 3 days but no luck. All points in this discussion are
correct...but you guys were talking about 2 different things.
Here's what I'm looking for. I have an n-tier app. In my Data layer, I
have a DataSet "Component" class that I have populated with 1
TableAdapter. I'll call it UserTableAdapter. You can add a Query into
the TableAdapter and use a stored procedure. As Dick was explaining, the
TableAdapter only returns a DataTable: 1 table = 1 recordset. But what
if you have a stored procedure where you pass the User ID and retrieve 3
recordsets: User Links, User Fav Cars, User Fav Books. Can we actually
run the stored procedure and have access to all 3 recordsets using the
"DataSet Component Class"? If so, how? If not, what's the alternative
to accomplish this?
Dick, this may help shed some light...although I can't replicated how
this guy was able to to fill a Dataset...still trying to figure that
out.
http://www.15seconds.com/issue/050721.htm
Scott G Rupp
MartialWeb.com
http://www.MartialWeb.com
Kick it with us!