C#Net2008 Extra XML Data to Update SQL SERVER

[LennieKuah]

Hi Good Guys,
I need your help. Please Help me.

I am trying to extra CustomerID, CompanyName, from XML File to Update SQL SERVER using xpath function. Being new to XML I don't know how to do it. Please help me with sample coding so that I can learn the coding logic to make it work.

Here are the xml file contents:

<?xml version="1.0" encoding="utf-8"?> 
<!--File Exported on 21/05/2010 12:26:48 p.m.--> 
<table> 
 <row> 
     <CustomerID>CHOPS</CustomerID> 
     <CompanyName>Chop-suey Chinese</CompanyName> 
     <OrdDate>01/03/2010</OrdDate> 
    <ReqDate>02/03/2010</ReqDate> 
    <ShipDate>03/03/2010</ShipDate> 
    <TransFee>7555.55</TransFee> 
</row> 
<row> 
    <CustomerID>CHOPS</CustomerID> 
    <CompanyName>Chop-suey Chinese</CompanyName> 
    <OrdDate>03/03/2010</OrdDate> 
    <ReqDate>04/03/2010</ReqDate> 
    <ShipDate>05/03/2010</ShipDate> 
    <TransFee>123.45</TransFee> 
</row> 
<row> 
    <CustomerID>CHOPS</CustomerID> 
    <CompanyName>Chop-suey Chinese</CompanyName> 
    <OrdDate>03/03/2010</OrdDate> 
    <ReqDate>04/03/2010</ReqDate> 
    <ShipDate>05/03/2010</ShipDate> 
    <TransFee>987.65</TransFee> 
</row> 
  
</table>

Thank you for your help.

Have a Good Day,

cheers,
Lennie