x
login about faq Site discussion (meta-askssc)

How filestream in used in Uploading a text or image file

Can anybody please sugges me, I need to upload a file from my application and want it to store in a filegroup of Filestream and want to keep a reference for that in any column of my table, how can i do that

more ▼

asked Jun 28 '12 at 04:45 AM in Default

ritesh.grover gravatar image

ritesh.grover
0 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Once you have everything configured, then you access it normally using the T-SQL as the field stored on file stream is mostly varbinary(max). SQL Server than takes care about everything under the hood.

Second option is to access the file stream using managed API.

You can check examples on SimpleTalk An Introduction to SQL Server FileStream, or MSDN Getting Started with FILESTREAM Storage.

more ▼

answered Jun 28 '12 at 05:14 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
20.3k 5 10 20

Thanks Pavel for such a quick Response

Jun 29 '12 at 11:32 AM ritesh.grover

If this helped you, you can accept the answer so everybody knows that this issue was solved and it helped to solve your problem.

Jun 29 '12 at 11:45 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x7
x5
x5

asked: Jun 28 '12 at 04:45 AM

Seen: 390 times

Last Updated: Jun 29 '12 at 11:45 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.