Is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database?

Question

Code Experts !

is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?

Update (1)

i want to write in a memo field and store it using identifiers like sessions and time stamps for example writing a memo with the session "subject" and session "dateANDtime" to be stored as "mysubject-12/12/2010-11:56pm.rtf"

i need of course a suggestion how to retrieve the file. can i build hyperlink programmatically?

Something beyond File.Save(path/filename)? – DOK Jan 14 '11 at 15:23 — DOK, Jan 14 '11 at 15:23

score 3 · Accepted Answer · answered Jan 14 '11 at 16:37

3

If you're on SQL 2008, do a search for FILESTREAM. That should solve your problem.

answered Jan 14 '11 at 16:37

Alex7575

65
2

score 2 · Answer 2 · answered Jan 14 '11 at 15:41

2

Object obj = // your object
XmlSerializer serializer = new XmlSerializer(this.GetType());
TextWriter textWriter = new StreamWriter(context.Server.MapPath("~/App_Data/Name.xml"));
serializer.Serialize(textWriter, this);
textWriter.Close();

answered Jan 14 '11 at 15:41

Sebastiaan

432
1
4
22

score 0 · Answer 3 · answered Jan 14 '11 at 15:24

0

Store them in files and write those files to the drives using MapPath function.

answered Jan 14 '11 at 15:24

Nirmal

1,223
18
32

Is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database?

is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?

3 Answers3