Ini bos file xmlnya
mohon bantuanya membaca xml ini ke data gridview n tulis xml dari data base sql
server 2000
sebenernya saya udah bisa tulis xml dr database tapi format xmlnya beda sama
yang dibawah ini
mohon pecerahan...........
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='NOFPK' rs:number='1' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='14'/>
</s:AttributeType>
<s:AttributeType name='NOSJP' rs:number='2' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='19'/>
</s:AttributeType>
<s:AttributeType name='TGLSJP' rs:number='3' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='JNSPELSJP' rs:number='4'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='NOKAPST' rs:number='5'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='16'/>
</s:AttributeType>
<s:AttributeType name='PISAPST' rs:number='6'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='1'/>
</s:AttributeType>
<s:AttributeType name='JNSPSTSJP' rs:number='7'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='MRPSTSJP' rs:number='8'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='7'/>
</s:AttributeType>
<s:AttributeType name='TGLDTGSJP' rs:number='9'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='TGLPLGSJP' rs:number='10'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='TGLRJKAWAL' rs:number='11'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='NORJKAWALS' rs:number='12'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='PPKRJKAWAL' rs:number='13'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='8'/>
</s:AttributeType>
<s:AttributeType name='DIAGPPK' rs:number='14'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='8'/>
</s:AttributeType>
<s:AttributeType name='DIAGRS' rs:number='15'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='3'/>
</s:AttributeType>
<s:AttributeType name='TGLVERSJP' rs:number='16'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='BYTAGSJP' rs:number='17'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='BYVERSJP' rs:number='18'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='BYSTJSJP' rs:number='19'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='JMLKSSJP' rs:number='20'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='JMLTSJP' rs:number='21'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='CATKHSSJP' rs:number='22'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='25'/>
</s:AttributeType>
<s:AttributeType name='FLAGAKHIRS' rs:number='23'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='FLAGENTRYS' rs:number='24'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='FLAGPRSKLA' rs:number='25'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='float' dt:maxLength='8'
rs:precision='15' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='IDUSERSJP' rs:number='26'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='5'/>
</s:AttributeType>
<s:AttributeType name='NIPSTJSJP' rs:number='27'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='5'/>
</s:AttributeType>
<s:AttributeType name='PPKPELSJP' rs:number='28'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='8'/>
</s:AttributeType>
<s:AttributeType name='FLAGPSTRS' rs:number='29'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='5'/>
</s:AttributeType>
<s:AttributeType name='TGLSTJKASI' rs:number='30'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='NIPSTJKASI' rs:number='31'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='5'/>
</s:AttributeType>
<s:AttributeType name='TGLSTJRS' rs:number='32'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='NAMASTJRS' rs:number='33'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str'
dt:maxLength='7'/>
</s:AttributeType>
<s:AttributeType name='BYTAGOBTSJ' rs:number='34'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='i2' dt:maxLength='2'
rs:precision='5' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='BYVEROBTSJ' rs:number='35'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='i2' dt:maxLength='2'
rs:precision='5' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='BYSTJOBTSJ' rs:number='36'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='i2' dt:maxLength='2'
rs:precision='5' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row NOFPK='1301R0090310**' NOSJP='1301R0090310Y917181'
TGLSJP='2009/12/26 00:00:00' JNSPELSJP='4' NOKAPST='1041003373252'
JNSPSTSJP='1' MRPSTSJP='3252' TGLDTGSJP='2009/12/26 00:00:00'
TGLPLGSJP='2010/01/05 00:00:00' TGLRJKAWAL='2009/12/26 00:00:00'
NORJKAWALS='0' DIAGPPK='Z51' DIAGRS='Z51'
TGLVERSJP='26/03/2010 00:00:00' BYTAGSJP='1900862' BYVERSJP='1900862'
BYSTJSJP='1900862' JMLKSSJP='1' JMLTSJP='0' CATKHSSJP='ASKES
DAN RKZ JAYA' FLAGAKHIRS='0' FLAGENTRYS='0' FLAGPRSKLA='1'
IDUSERSJP='00000' PPKPELSJP='1301R009' FLAGPSTRS='False'
TGLSTJKASI='2010/03/26 00:00:00' NIPSTJKASI='02269'
TGLSTJRS='2010/03/26 00:00:00' NAMASTJRS='Juliani'
BYTAGOBTSJ='0' BYVEROBTSJ='0' BYSTJOBTSJ='0'/>
<z:row NOFPK='1301R0090310**' NOSJP='1301R0090310Y917238'
TGLSJP='2009/12/28 00:00:00' JNSPELSJP='4' NOKAPST='1041002195152'
JNSPSTSJP='1' MRPSTSJP='5152' TGLDTGSJP='2009/12/28 00:00:00'
TGLPLGSJP='2010/01/02 00:00:00' TGLRJKAWAL='2009/12/28 00:00:00'
NORJKAWALS='0' DIAGPPK='Z51' DIAGRS='Z51'
TGLVERSJP='26/03/2010 00:00:00' BYTAGSJP='1127635' BYVERSJP='1127635'
BYSTJSJP='1127635' JMLKSSJP='1' JMLTSJP='0' CATKHSSJP='ASKES
DAN RKZ JAYA' FLAGAKHIRS='0' FLAGENTRYS='0' FLAGPRSKLA='1'
IDUSERSJP='00000' PPKPELSJP='1301R009' FLAGPSTRS='False'
TGLSTJKASI='2010/03/26 00:00:00' NIPSTJKASI='02269'
TGLSTJRS='2010/03/26 00:00:00' NAMASTJRS='Juliani'
BYTAGOBTSJ='0' BYVEROBTSJ='0' BYSTJOBTSJ='0'/>
<z:row NOFPK='1301R0090310**' NOSJP='1301R0090310Y917256'
TGLSJP='2009/12/28 00:00:00' JNSPELSJP='4' NOKAPST='1011001653448'
JNSPSTSJP='1' MRPSTSJP='3448' TGLDTGSJP='2009/12/28 00:00:00'
TGLPLGSJP='2010/01/06 00:00:00' TGLRJKAWAL='2009/12/28 00:00:00'
NORJKAWALS='0' DIAGPPK='Z51' DIAGRS='Z51'
TGLVERSJP='26/03/2010 00:00:00' BYTAGSJP='2468306' BYVERSJP='2468306'
BYSTJSJP='2468306' JMLKSSJP='1' JMLTSJP='0' CATKHSSJP='ASKES
DAN RKZ JAYA' FLAGAKHIRS='0' FLAGENTRYS='0' FLAGPRSKLA='1'
IDUSERSJP='00000' PPKPELSJP='1301R009' FLAGPSTRS='False'
TGLSTJKASI='2010/03/26 00:00:00' NIPSTJKASI='02269'
TGLSTJRS='2010/03/26 00:00:00' NAMASTJRS='Juliani'
BYTAGOBTSJ='0' BYVEROBTSJ='0' BYSTJOBTSJ='0'/>
</rs:data>
</xml>
