Aman Gupta

Aman Gupta

  • NA
  • 1
  • 0

Need Code for fetching values of XML file using VB 6.0

Apr 30 2010 3:31 AM
This is how my XML file look

<datapoint><name>fcproc</name><pid>5928</pid><time>4/23/2010 16:58:1</time><machine>DEWDFTF11382S</machine><CPU>0.926438326382987</CPU><CPUTime>6406.25</CPUTime><VirtualBytes>233956</VirtualBytes><PrivateBytes>49748</PrivateBytes><HandleCount>1454</HandleCount><Threads>81</Threads> </datapoint>

<datapoint><name>fccache</name><pid>740</pid><time>4/23/2010 17:3:7</time><machine>DEWDFTF11382S</machine><CPU>0.925834485482915</CPU><CPUTime>13109.375</CPUTime><VirtualBytes>236996</VirtualBytes><PrivateBytes>158520</PrivateBytes><HandleCount>601</HandleCount><Threads>21</Threads> </datapoint>

<datapoint><name>crcache</name><pid>332</pid><time>4/23/2010 17:3:7</time><machine>DEWDFTF11382S</machine><CPU>1.85166897096583</CPU><CPUTime>14531.25</CPUTime><VirtualBytes>130388</VirtualBytes><PrivateBytes>57584</PrivateBytes><HandleCount>1614</HandleCount><Threads>27</Threads> </datapoint>

I need to fetch the values and dump it into SQL Server database. Please help