|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Large Upload to SQL - Async?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. Show quote "Patrick" <psarnow***@mgasystems.com> wrote in message news:1143841718.501039.280720@v46g2000cwv.googlegroups.com... > 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... > SqlParameter.Offset is what I was looking for... thanks!
Kevin English wrote: Show quote > Take a look at SqlParameter.Offset. This does seem clunkier to me than > AppendChunk. On 31 Mar 2006 13:48:38 -0800, "Patrick" <psarnow***@mgasystems.com> wrote: If showing progress would solve your problem take a look at the progress bar in>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... ..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
-- Show quote____________________________________ 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. __________________________________ "Otis Mukinfus" <ph***@emailaddress.com> wrote in message news:igjr225n9rlr0tsft7od8krdd240jf061j@4ax.com... > On 31 Mar 2006 13:48:38 -0800, "Patrick" <psarnow***@mgasystems.com> > wrote: > >>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... > > 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  |
|||||||||||||||||||||||
Other interesting topics