Last post May 10, 2013 03:51 PM by thirumaran007
Member
211 Points
715 Posts
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.
Contributor
4954 Points
1726 Posts
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/
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.
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
3. Insert XML data to SQL
http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/eadbbca1-4d85-478c-9849-855dd7d22a5c/
With Friendly,
Thirumaran