Monday, March 26, 2012

web service dataset

I have a web service that calls SP's and returning a dataset. At times the
data is coming back as 0 and if that is the case i need to display nothing
just leaving it blank. With accessing data like this how can I check to see
if the data is 0?

example:

<Books>
<computers>
<type>Programming</type>
<ISDN>0</ISDN>
</computer>
</Books
if ISDN is 0 i need to display nothing. how can i do that?
I'm using a datalist to display the output. and calling the web method in
the web service.
vb.net code to all the web service

public GetAllBooks()
dim me as getbooks.book = new getbooks.book
dim ds as new dataset
dim dvBook as new dataview

ds = me.GetBooks()
dvBook = ds.table(0).defaultView
dlBooks.datasource = dbBook
dlBook.databind

end subHi Mike,

As for the DataSet's checking problem you mentioned, I think Shailesh's
suggestion that use the select method of the datatable is considerable if
the the <ISDN> is just a simple column in the DAtaTable. Also, since the
DataSet has GetXml method which can help return the dataset's xml
representation, you can use the APIS under the System.Xml namespace to
query this <ISDN> element (such as using the SelectSingleNode with
specified xpath). Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

0 comments:

Post a Comment