parse xml file insert into database

[jgn1013]

This is what i'm currently doing, but what I would like is parse the xml only get phone, cellphone, name & userid.

I'm getting a http stream xml file: sample below

<root>
<bhcontact name="john doe" userid="123">
  <address>my address here</address>
 <phone>123-456-7890</phone>
  <cellphone>123-456-7888</cellphone>
   <state>GA</state>
   <zip>12345</zip>
</bhcontact>
</root>


DataSet xmlDS = new DataSet();
DataRow dataRow;
DataSet dbDS = new DataSet("contactxml");
xmlDS.ReadXml(new StringReader("XML STRING HERE--see above"));
trcCon.Open();
			SqlDataAdapter trcDA = new SqlDataAdapter("Select * from clientcontact where 1=2", trcCon);
			trcDA.Fill(dbDS, "contactxml");
			foreach(DataRow drow in xmlDS.Tables[0].Rows)
			{
				dataRow = dbDS.Tables[0].NewRow();
				for(int i=1; i <xmlDS.Tables[0].Columns.Count; i++)
{
 dataRow[i] = drow[i];
}
dbDS.Tables[0].Rows.Add(dataRow);
				SqlCommandBuilder trcCmd = new SqlCommandBuilder(trcDA);
				trcDA.Update(dbDS, "contactxml");
				
				trcCon.Close();

[kenobewan]

One way may be to alter your select statement. HTH.