how to save/read content of a RichTextBox to/from binary field in Ms.SQL Server ?

[Asking]

Hi all,

how to save/read content of a RichTextBox to/from binary field in Ms.SQL
Server ?

I want to do save and read operation... I couldn't it

Thank you

 

[Marc Gravell]

Well, for RTF "text" or "ntext" might be more suitable... and more
convenient; but if you use an encoding you can get a binary
representation (e.g. byte[] raw =
System.Text.Encoding.UTF8.GetBytes(someControl.Rtf) and GetString()
for the reverse).

What have you tried? And how are you handling data (DataSet /
classes / what? Parameterised sql / stored procedures?)

Marc