Getting a multiple recordset into a datalist

[Roffers]

Okay, so I have my stored procedure that looks something like this
AS

SELECT VAL 1, VAL 2
SELECT VAL1, VAL2
GO

And I need to display these into a datalist control, does anyone have
any idea how I can go about this?

Any examples of code in C# or VB.NET would be greatly appreciated.

Cheers
Mark

 

[sloan]

You can use

UNION
or
UNION ALL
inside the stored procedure


OR

Manually loop thru the IDataReader
and manually create ListItem values. And append them to the DataList. (I
think this works for DataList, I know it does for DropDownList)

...