Data Reader Serialisation in web service

[shalender]

Hello All, Could any of you please tell me how can i return datareader from web service . How can i serialize datareader ??????????? Regards, Gandhi

[Jeffry van de Vuurst]

You cannot serialize a datareader as far as I know. It doesn't implement the ISerializable interface. However, it does inherit from MarshalByRefObject so you could return a reference to the datareader from your webservice. So you could do something like this: SqlDataReader dr = myWebService.GetDatareader(); Just be sure to close the connection when you're done with the datareader! Depending on your needs, you might be better of with a DataSet, e.g. if you need to hold on to the data for a while. HTH, Jeffry