Large Upload to SQL - Async?

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Is there any possible way to upload a file into an image field in SQL
Server asynchronously?

Our users upload a lot of large files into a SQL Server, and we have no
way of showing them progress. ADO had an "AppendChunk" method, but it
doesn't look like .Net has anything similar. This seems like a big
oversight to me...
 
Take a look at SqlParameter.Offset. This does seem clunkier to me than
AppendChunk.
 
Is there any possible way to upload a file into an image field in SQL
Server asynchronously?

Our users upload a lot of large files into a SQL Server, and we have no
way of showing them progress. ADO had an "AppendChunk" method, but it
doesn't look like .Net has anything similar. This seems like a big
oversight to me...
Click to expand...

If showing progress would solve your problem take a look at the progress bar in
..NET 2005. It has a marquee setting that keeps the blocks in a progress bar
moving like marquee until you tell it to stop (at the end of the upload).

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
 
SqlBulkCopy

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top