xml file to sql server database

Question

Ih I hava a xml file and i would like to tranfer him to a sql server database could anyone give me some hints about it???

Tanvir Huda · Answer

well i think u can parse the xml file and build a query using the xml file and then execute that using Oledb or SqlConnection

Administrator · Answer

See your other thread

Administrator · Answer

if i m not wrong u can use the dataAdapter class's readxml(file name) to read the xml file.so now data adopter have the user xml file info. i.e . table rows and column.so now u can write querry of insert into table.to insert data.