insert xml data into sql server?

[maltchev]

i need to insert data from an xml file into sql server table.
the xml file contains only one record.
how to insert the data? how to map the names of the fields in the xml file
and the table?
thank you in advance.

 

[news.microsoft.com]

Hey,Try create a DataSet Instance,load data xml file in it,with
SqlDataAdapter may solove this problem.

--
----------Ñ©ÔÆÓ¥
¾´ÉÏ--------------

MSN:[email protected]
ÐÅÄî:·ÖÏí֪ʶ¡¢¹²
´´¼¤Çé¡¢¹²Í¬³É¾Í

Blog:http://shanquan.blogone.net