March 21st, 2011 07:58 AM
#1
VB 6.0 to read dataset xml response from webservice
Hi All,
I have a project that need get some values from web service. If I want to get a single value it is easy, but webservice returning a dataset to me. So I don't know how can I get the values from dataset with Vb 6.0
I want to get Par_Param_Kod and Par_Param_Ad value from xml that web service returned.
It is an urgent issue. I would be glad if you help
the xml code returned by web service is below :
<?xml version="1.0" encoding="UTF-8"?>
<DataSet xmlns="http://tempuri.org/">
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:Locale="tr-TR">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table" msprop:REFCursorName="REFCursor">
<xs:complexType>
<xs:sequence>
<xs:element name="Par_Param_Kod" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Param_Ad" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Param_No" msprop:OraDbType="113" type="xs:long" minOccurs="0" />
<xs:element name="Par_IParam_Kod" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Ana_Param_Kod" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger1" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger2" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger3" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger4" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger5" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger6" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger7" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger8" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger9" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger10" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger11" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger12" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger13" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger14" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger15" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger16" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger17" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger18" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger19" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Alan_Deger20" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="RPAD_x0028_TO_CHAR_x0028_PAR_GECER_BAS_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="RPAD_x0028_TO_CHAR_x0028_PAR_GECER_SON_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="KayitYapan" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Kayit_Zmn" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" />
<xs:element name="KayitTrx_Kod" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Kayit_Drm" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="IptalYapan" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Iptal_Zmn" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" />
<xs:element name="OnayYapan" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Onay_Zmn" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" />
<xs:element name="Onay_Drm" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Par_Grup_Kod" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Gecerlilik_x0020_Baslangic_x0020_Tarihi" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
<xs:element name="Gecerlilik_x0020_Bitis_x0020_Tarihi" msprop:OraDbType="126" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<NewDataSet xmlns="">
<Table diffgr:id="Table1" msdata:rowOrder="0">
<Par_Param_Kod>001</Par_Param_Kod>
<Par_Param_Ad>NORMAL</Par_Param_Ad>
<Par_Param_No>1</Par_Param_No>
<Par_Alan_Deger1>01</Par_Alan_Deger1>
<RPAD_x0028_TO_CHAR_x0028_PAR_GECER_BAS_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>2</RPAD_x0028_TO_CHAR_x0028_PAR_GECER_BAS_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>
<RPAD_x0028_TO_CHAR_x0028_PAR_GECER_SON_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>2</RPAD_x0028_TO_CHAR_x0028_PAR_GECER_SON_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>
<KayitYapan>captiva</KayitYapan>
<Kayit_Zmn>2007-10-02T14:29:18+03:00</Kayit_Zmn>
<KayitTrx_Kod>PARTGPDG</KayitTrx_Kod>
<Kayit_Drm>A</Kayit_Drm>
<Par_Grup_Kod>KIYMSTGRB</Par_Grup_Kod>
<Gecerlilik_x0020_Baslangic_x0020_Tarihi>02/01/2007</Gecerlilik_x0020_Baslangic_x0020_Tarihi>
<Gecerlilik_x0020_Bitis_x0020_Tarihi>01/01/2075</Gecerlilik_x0020_Bitis_x0020_Tarihi>
</Table>
<Table diffgr:id="Table2" msdata:rowOrder="1">
<Par_Param_Kod>002</Par_Param_Kod>
<Par_Param_Ad>PERSONEL</Par_Param_Ad>
<Par_Param_No>2</Par_Param_No>
<Par_Alan_Deger1>02</Par_Alan_Deger1>
<RPAD_x0028_TO_CHAR_x0028_PAR_GECER_BAS_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>2</RPAD_x0028_TO_CHAR_x0028_PAR_GECER_BAS_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>
<RPAD_x0028_TO_CHAR_x0028_PAR_GECER_SON_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>2</RPAD_x0028_TO_CHAR_x0028_PAR_GECER_SON_TAR_x002C_CONVERTSQLSERVERDATEFORMAT_x0028_120_x0029__x0029__x002C_1_x002C__x0027__x0027__x0029_>
<KayitYapan>captiva</KayitYapan>
<Kayit_Zmn>2007-10-02T14:29:44+03:00</Kayit_Zmn>
<KayitTrx_Kod>PARTGPDG</KayitTrx_Kod>
<Kayit_Drm>A</Kayit_Drm>
<Par_Grup_Kod>KIYMSTGRB</Par_Grup_Kod>
<Gecerlilik_x0020_Baslangic_x0020_Tarihi>02/01/2007</Gecerlilik_x0020_Baslangic_x0020_Tarihi>
<Gecerlilik_x0020_Bitis_x0020_Tarihi>01/01/2075</Gecerlilik_x0020_Bitis_x0020_Tarihi>
</Table>
</NewDataSet>
</diffgr:diffgram>
</DataSet>
Tags for this Thread
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks