How to store Excel file as XML and pass this XML to stored procedure? [Answered]RSS

• • Reply
  rpk2006

  Member

  211 Points

  715 Posts

  How to store Excel file as XML and pass this XML to stored procedure?

  May 10, 2013 02:26 PM|rpk2006|LINK

  I want to read an Excel file and store the result as XML to a DataSet. I want to pass this XML data to stored procedure as a parameter.

• • Reply
  thirumaran00...

  Contributor

  4954 Points

  1726 Posts

  Re: How to store Excel file as XML and pass this XML to stored procedure?

  May 10, 2013 03:51 PM|thirumaran007|LINK

  1. First you have to fill the excel data indata set 

  please follow these linke http://www.codeproject.com/Tips/509179/Read-Excel-File-into-DataSet-in-ASP-NET-Using-Csha 

  2. Get XML from data set 

  string strXML=dataSet.GetXml()

  3. Insert XML data to SQL

  http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/eadbbca1-4d85-478c-9849-855dd7d22a5c/ 
  
  

  Please remember to click "Mark as Answer" on this post if it helped you
  
  With Friendly,
  Thirumaran