Return a SqlDataReder

[Asier]

Hello,

I've a webService thar read from my database and let results in a
SqlDataReader. I want to return this datreader to my ASP.NET page but it
fail.
This is my code:
***************************

Dim cnConexion As New SqlConnection("..................")

<WebMethod()> Public Function fLeerTodasCIAs() As SqlDataReader

Dim drCIAS As SqlDataReader

Dim cmd As New SqlCommand("spCIASLeerTodas", cnConexion)

cmd.CommandType = CommandType.StoredProcedure

cnConexion.Open()

drCIAS = cmd.ExecuteReader(CommandBehavior.CloseConnection)

drCIAS.Close()

End Function

**************************

What is the problem?? thanks

Asier

 

[Sami Vaaraniemi]

Hello,

I've a webService thar read from my database and let results in a
SqlDataReader. I want to return this datreader to my ASP.NET page but it
fail.
This is my code:
***************************

Dim cnConexion As New SqlConnection("..................")

<WebMethod()> Public Function fLeerTodasCIAs() As SqlDataReader

Dim drCIAS As SqlDataReader

Dim cmd As New SqlCommand("spCIASLeerTodas", cnConexion)

cmd.CommandType = CommandType.StoredProcedure

cnConexion.Open()

drCIAS = cmd.ExecuteReader(CommandBehavior.CloseConnection)

drCIAS.Close()

End Function

**************************

What is the problem?? thanks

You cannot return an SqlDataReader from a Web service as an SqlDataReader is
not serializable over SOAP. Instead, return a DataSet or an array of custom
objects. For an example on how to return a DataSet, see:

http://msdn.microsoft.com/library/d.../html/cpconconsumingdatasetfromwebservice.asp

Regards,
Sami