SQL Filestream - ASP.NET VB

5 posts, 0 answers
  1. Kris
    Kris avatar
    1 posts
    Member since:
    Jun 2011

    Posted 23 Jun 2011 Link to this post

    I am trying to allow my web application to support multiple file selection/uploads but cannot figure it out. Let me get into more detail, I am writing an application for real estate management and need to be able to upload hundreds of files at once. We were going to do this with Microsoft SQL Server Filestream and RADAsyncUpload. We have some additional fields that need to be filled for the photos also. We are writing this in Visual Basic and any help is appreciated.


    Thank you,
    Kris
  2. Peter Filipov
    Admin
    Peter Filipov avatar
    1028 posts

    Posted 24 Jun 2011 Link to this post

    Hi Kristopher,

    I have already answered your support ticket regarding the same issue. To avoid duplication, let continue the communication in the support ticket.

    Regards,
    Peter Filipov
    the Telerik team

    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

  3. Atlas
    Atlas avatar
    97 posts
    Member since:
    Jun 2009

    Posted 23 Jul 2012 Link to this post

    Do you have a code sample that supports SQL filestream with AsynchUpload?
    Anything special I need to know in order to accomplish it?
    C# please.
  4. Vasssek
    Vasssek avatar
    184 posts
    Member since:
    Aug 2010

    Posted 26 Jul 2012 Link to this post

    Hello,

    Does somebody have example with SQL filestream and AsyncUpload in C#, please ?

    Best regards

    Vasssek
  5. Bozhidar
    Admin
    Bozhidar avatar
    1188 posts

    Posted 26 Jul 2012 Link to this post

    Hi,

    You can see how to insert and retrieve files from a SQL Filestream table in the following article:
    http://blogs.msdn.com/b/spike/archive/2011/02/28/inserting-a-file-into-a-filestream-table-from-c-and-how-to-get-it-back-as-well.aspx 

    All you need to do to make it work with RadAsyncUpload is get the image bytes from the uploaded file. You can do this with the following code:
    protected void AsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
    {
        using (Stream stream = e.File.InputStream)
        {
            byte[] imageData = new byte[stream.Length];
            stream.Read(imageData, 0, (int)stream.Length);
            //Insert into Database
        }
    }


    Kind regards,
    Bozhidar
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top