Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / April 2006

Tip: Looking for answers? Try searching our database.

Large Upload to SQL - Async?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patrick - 31 Mar 2006 22:48 GMT
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...
Kevin English - 01 Apr 2006 00:10 GMT
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?
[quoted text clipped - 3 lines]
> doesn't look like .Net has anything similar.  This seems like a big
> oversight to me...
Patrick - 04 Apr 2006 16:51 GMT
SqlParameter.Offset is what I was looking for... thanks!

> Take a look at SqlParameter.Offset.  This does seem clunkier to me than
> AppendChunk.
Otis Mukinfus - 01 Apr 2006 01:51 GMT
>Is there any possible way to upload a file into an image field in SQL
>Server asynchronously?
[quoted text clipped - 3 lines]
>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
William (Bill) Vaughn - 01 Apr 2006 19:38 GMT
SqlBulkCopy

Signature

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

>>Is there any possible way to upload a file into an image field in SQL
>>Server asynchronously?
[quoted text clipped - 15 lines]
> http://www.arltex.com
> http://www.tomchilders.com 

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.