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...

Re: Large Upload to SQL - Async? by Kevin

Kevin
Fri Mar 31 17:10:52 CST 2006

Take a look at SqlParameter.Offset. This does seem clunkier to me than
AppendChunk.

"Patrick" <psarnowski@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...
>



Re: Large Upload to SQL - Async? by Otis

Otis
Fri Mar 31 18:51:59 CST 2006

On 31 Mar 2006 13:48:38 -0800, "Patrick" <psarnowski@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

Re: Large Upload to SQL - Async? by William

William
Sat Apr 01 12:38:10 CST 2006

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.
__________________________________

"Otis Mukinfus" <phony@emailaddress.com> wrote in message
news:igjr225n9rlr0tsft7od8krdd240jf061j@4ax.com...
> On 31 Mar 2006 13:48:38 -0800, "Patrick" <psarnowski@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



Re: Large Upload to SQL - Async? by Patrick

Patrick
Tue Apr 04 10:51:16 CDT 2006

SqlParameter.Offset is what I was looking for... thanks!

Kevin English wrote:
> Take a look at SqlParameter.Offset. This does seem clunkier to me than
> AppendChunk.