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 subFrom what I understand you want have to filter the rows returned from the
webservice. Why don;t you try using ds.Tables[0].Select ("ISBN !=0")
and bind the returns rows array.
Thanks
"Mike" wrote:

> 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 se
e
> 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 sub
>
>
>
Hi 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