|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
finding data in datasetI 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! 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! > 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! >> > > 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! >>> >> >> > > |
|||||||||||||||||||||||