Home All Groups Group Topic Archive Search About
Author
9 Jan 2006 4:45 AM
VB Programmer
I am using VB.NET 2005.

I just filled a dataset from an XML webservice.

Here is a snippet of the data....
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
    <NewDataSet xmlns="">
      <Rates diffgr:id="Rates1" msdata:rowOrder="0">
        <Quote>AUD/JPY</Quote>
        <Display>85.69/77</Display>
        <UpdateTime>2006-01-08T23:15:29.0000000-05:00</UpdateTime>
      </Rates>
      <Rates diffgr:id="Rates2" msdata:rowOrder="1">
        <Quote>AUD/USD</Quote>
        <Display>0.7520/24</Display>
        <UpdateTime>2006-01-08T23:14:18.0000000-05:00</UpdateTime>
      </Rates>

How do I find the <Display> value for the <Quote> named 'AUD/USD'?

Thanks!

Author
9 Jan 2006 11:49 PM
VB Programmer
Any ideas on this?

Show quote
"VB Programmer" <d***@emailme.com> wrote in message
news:uQT7zdNFGHA.208@tk2msftngp13.phx.gbl...
>I am using VB.NET 2005.
>
> I just filled a dataset from an XML webservice.
>
> Here is a snippet of the data....
> <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
> xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
>    <NewDataSet xmlns="">
>      <Rates diffgr:id="Rates1" msdata:rowOrder="0">
>        <Quote>AUD/JPY</Quote>
>        <Display>85.69/77</Display>
>        <UpdateTime>2006-01-08T23:15:29.0000000-05:00</UpdateTime>
>      </Rates>
>      <Rates diffgr:id="Rates2" msdata:rowOrder="1">
>        <Quote>AUD/USD</Quote>
>        <Display>0.7520/24</Display>
>        <UpdateTime>2006-01-08T23:14:18.0000000-05:00</UpdateTime>
>      </Rates>
>
> How do I find the <Display> value for the <Quote> named 'AUD/USD'?
>
> Thanks!
>
Author
11 Jan 2006 1:16 PM
Adrian Moore
Hi,

DataRow[] rows = DataSet.Tables("Rates").Select("Quote='AUD/USD');

double quote = rows[0].Item["Quote"];

Hope this helps
Ad.

Show quote
"VB Programmer" <d***@emailme.com> wrote in message
news:OOz9QdXFGHA.2892@TK2MSFTNGP10.phx.gbl...
> Any ideas on this?
>
> "VB Programmer" <d***@emailme.com> wrote in message
> news:uQT7zdNFGHA.208@tk2msftngp13.phx.gbl...
>>I am using VB.NET 2005.
>>
>> I just filled a dataset from an XML webservice.
>>
>> Here is a snippet of the data....
>> <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
>> xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
>>    <NewDataSet xmlns="">
>>      <Rates diffgr:id="Rates1" msdata:rowOrder="0">
>>        <Quote>AUD/JPY</Quote>
>>        <Display>85.69/77</Display>
>>        <UpdateTime>2006-01-08T23:15:29.0000000-05:00</UpdateTime>
>>      </Rates>
>>      <Rates diffgr:id="Rates2" msdata:rowOrder="1">
>>        <Quote>AUD/USD</Quote>
>>        <Display>0.7520/24</Display>
>>        <UpdateTime>2006-01-08T23:14:18.0000000-05:00</UpdateTime>
>>      </Rates>
>>
>> How do I find the <Display> value for the <Quote> named 'AUD/USD'?
>>
>> Thanks!
>>
>
>
Author
12 Jan 2006 2:05 PM
VB Programmer
Thanks Ad!

Show quote
"Adrian Moore" <queryadata***@hotmail.com> wrote in message
news:u9JzJFrFGHA.644@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> DataRow[] rows = DataSet.Tables("Rates").Select("Quote='AUD/USD');
>
> double quote = rows[0].Item["Quote"];
>
> Hope this helps
> Ad.
>
> "VB Programmer" <d***@emailme.com> wrote in message
> news:OOz9QdXFGHA.2892@TK2MSFTNGP10.phx.gbl...
>> Any ideas on this?
>>
>> "VB Programmer" <d***@emailme.com> wrote in message
>> news:uQT7zdNFGHA.208@tk2msftngp13.phx.gbl...
>>>I am using VB.NET 2005.
>>>
>>> I just filled a dataset from an XML webservice.
>>>
>>> Here is a snippet of the data....
>>> <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
>>> xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
>>>    <NewDataSet xmlns="">
>>>      <Rates diffgr:id="Rates1" msdata:rowOrder="0">
>>>        <Quote>AUD/JPY</Quote>
>>>        <Display>85.69/77</Display>
>>>        <UpdateTime>2006-01-08T23:15:29.0000000-05:00</UpdateTime>
>>>      </Rates>
>>>      <Rates diffgr:id="Rates2" msdata:rowOrder="1">
>>>        <Quote>AUD/USD</Quote>
>>>        <Display>0.7520/24</Display>
>>>        <UpdateTime>2006-01-08T23:14:18.0000000-05:00</UpdateTime>
>>>      </Rates>
>>>
>>> How do I find the <Display> value for the <Quote> named 'AUD/USD'?
>>>
>>> Thanks!
>>>
>>
>>
>
>

AddThis Social Bookmark Button