marky102
asked on
web service
how do i go about writing a .csv excel file 2007 data to sql2008 using a web service ?
what is the best approach ?
what is the best approach ?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
So you want to send the service the file and have the service write the records to the database?
If that is the case then just use the code from a regular asp.net project that does this and use it in the service. Consume the service from your application and pass the file stream as the input for the service. If you expect to work with very large files things will be a lot trickier.
If that is the case then just use the code from a regular asp.net project that does this and use it in the service. Consume the service from your application and pass the file stream as the input for the service. If you expect to work with very large files things will be a lot trickier.
ASKER
good approach
ASP.NET
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER