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)
...
"Roffers" <mr*****@hotmail.comwrote in message
news:11**********************@m7g2000cwm.googlegro ups.com...
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