Passing sqldatareader from web service.

mike55

mike55

Well-known member
Joined
Mar 26, 2004
Messages
726
Location
Ireland
Hi all

What is the most effective way of passing a sqlDataReader from a web service back to a web application? I have tried to pass it back as an object data type, but problems arise when I try to convert that object back to an sqldatareader using ctype. Any suggestions?

Mike55.
 
You cant is the simple answer. The SqlDataReader requires direct access to the SQL Server and this cant be guaranteed if you are returning it from a webmethod.

You are better simply returning the relevant data to the client from the method instead.
 
Back
Top