Sending a Row of Data Through a Web Service

[RFEULINGatRITE]

Hello,

I am creating a web service and I want it to retrieve and return a row of data. I know I can use a dataset to do this but it’s overly bulky to do so. For example, it takes a quite awhile for a pocket pc to interpret the dataset from the web service. I’m looking for something lighter…

Is there any less bulky way to send a data table or a data column?

Thanks!

 

[ca8msm]

If you're only returning one row and you want it to be lightweight why not just return a delimited string? You could take this string once it it returned and make your own datatable from it but the actually process of sending/retreiving from the web service should be very quick and small in size.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[henslecd]

In the webservice function,

Function GetDataRow() as DataRow

Dim dr as New DataDrow

'Do some code to get the DataRow you want.

Return dr

End Function

 

[RFEULINGatRITE]

Thanks for the suggestions people.

A delimited string could be a good deal. I didn't realize that you could pass a datarow through a webservice as you cannot pass a datatable through. I tried it, it does work. As a datarow would it still work with non .Net apps?

And ideas on passing a table through without using a dataset?

Thanks again for the help!

 

[henslecd]

You can pass any object.

Function GetTable() as Table

Dim tbl as New Table
Dim row as new TableRow
Dim cell as new TableCell

row.controls.add(cell)
tbl.controls.add(row)

Return tbl

End Function

 

[RFEULINGatRITE]

Unfortunately you cannot pass datatables - it gives an error about not being able to serialize the data.

Thanks for the suggestion though.

 

[ca8msm]

You should be able to pass any object as far as I am aware so it may be a problem with the actual DataTable you are returning.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sunila7]

Datatable's are not serializable so you cannot pass them across webservice

Have a look at this link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306134

According to what I have been reading it should be possible in next version of .net framework.

http://weblogs.asp.net/cweyer/archive/2004/08/02/205798.aspx

Sunil