How do I Databind a Rich Text Box Control with MS SQL Server ntext field so it does not loose its rich text changes?
Posted on 2006-07-14
I have a simple Winforms application built in VB.Net 2003 were I am using a Rich Text Box Control to bind to a field on a MS SQL Server 2000 (ntext field called "Content" .
I have built the Command buttons to bold specific text sections and so on but when I save the data and reload it again changes to the content are made but the formating changes are not saved.
The binding code I am using is as follows;
RichTextBox_Content.DataBindings.Add(New System.Windows.Forms.Binding("Text", SQL_QuickDocEDIT_DataSet, "MSSP_QuickDoc_EDIT_SelectCommand.Content"))
Should I be using something else instead of "Text"? or Should I be binding to a different SQL datatype? or doing something else?
Thanks in Advance