retrieve data from xml to database

Question

hi i am working in windows form..in my xml file there are two tables...one table has rows[1]coloumns[7] and another table with rows[5]columns[5]...i have to get that data from both the tables and i have to insert in to another table in database please help me.....

Keyur Patel · Answer

Hi Please see following link for get data from two tables and insert in new datatable. It might be get hint from this link. http://stepbystepdotnet.wordpress.com/2012/09/13/how-to-join-two-data-tables-in-c-without-using-loop-in-linq/ http://www.c-sharpcorner.com/uploadfile/4d56e1/how-to-create-a-datatable-and-add-it-to-a-dataset/ http://www.c-sharpcorner.com/UploadFile/mahesh/ImportRow07092006195427PM/ImportRow.aspx

Laxmikant · Answer

You can use DataTable and read your xml file to this datatable by DataTable.ReadXml() method. Same you can add second xml file data to same or new datatable and merge both DataTable rows. and using SQLBulkCopy you can insert DataTable data to SQL Server. Below article will give you required steps for SQLBulkCopy http://dotnetmentors.com/c-sharp/bulk-upload-into-sql-server-using-sqlbulkcopy-and-c-sharp.aspx