How do I return multiple database rows in an asmx web service.

Question

I can return a single value in my webservice, but I can't figure out how to return multiple rows. I have an ILIST collection of the data from my database.

Answer 1

If the method of your web service returns arrays of objects, that should do the trick. So basically you just have to convert that IList to an array and, depending on what type of objects you have in the IList, fill some standard objects with the data to be returned.

Answer 2

Create a class that can hold all the rows, then return that class