Visual Basic

satc wrote:

Have you tried this before speaking ?
Or you are just speaking in theory ?

create table TestDataRTF (
   id int identity(1,1) primary key,
   textvalue varchar(100)
);

insert into TestDataRTF (textvalue) values ('initial');

select * from TestDataRTF;

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class DataForm
    Inherits System.Windows.Forms.Form

    'Form overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overrides Sub Dispose(ByVal disposing As Boolean)
        Try
            If disposing AndAlso components IsNot Nothing Then
                components.Dispose()
            End If
        Finally
            MyBase.Dispose(disposing)
        End Try
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
      Me.RichTextBox1 = New System.Windows.Forms.RichTextBox()
      Me.Save = New System.Windows.Forms.Button()
      Me.Clear = New System.Windows.Forms.Button()
      Me.Fetch = New System.Windows.Forms.Button()
      Me.SuspendLayout()
      '
      'RichTextBox1
      '
      Me.RichTextBox1.Location = New System.Drawing.Point(12, 12)
      Me.RichTextBox1.Name = "RichTextBox1"
      Me.RichTextBox1.Size = New System.Drawing.Size(149, 130)
      Me.RichTextBox1.TabIndex = 0
      Me.RichTextBox1.Text = ""
      '
      'Save
      '
      Me.Save.Location = New System.Drawing.Point(167, 41)
      Me.Save.Name = "Save"
      Me.Save.Size = New System.Drawing.Size(75, 23)
      Me.Save.TabIndex = 1
      Me.Save.Text = "Save row 1"
      Me.Save.UseVisualStyleBackColor = True
      '
      'Clear
      '
      Me.Clear.Location = New System.Drawing.Point(167, 70)
      Me.Clear.Name = "Clear"
      Me.Clear.Size = New System.Drawing.Size(75, 23)
      Me.Clear.TabIndex = 2
      Me.Clear.Text = "Clear"
      Me.Clear.UseVisualStyleBackColor = True
      '
      'Fetch
      '
      Me.Fetch.Location = New System.Drawing.Point(167, 12)
      Me.Fetch.Name = "Fetch"
      Me.Fetch.Size = New System.Drawing.Size(75, 23)
      Me.Fetch.TabIndex = 3
      Me.Fetch.Text = "Fetch row 1"
      Me.Fetch.UseVisualStyleBackColor = True
      '
      'DataForm
      '
      Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
      Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
      Me.ClientSize = New System.Drawing.Size(311, 171)
      Me.Controls.Add(Me.Fetch)
      Me.Controls.Add(Me.Clear)
      Me.Controls.Add(Me.Save)
      Me.Controls.Add(Me.RichTextBox1)
      Me.Name = "DataForm"
      Me.Text = "DataForm"
      Me.ResumeLayout(False)

   End Sub
   Friend WithEvents RichTextBox1 As System.Windows.Forms.RichTextBox
   Friend WithEvents Save As System.Windows.Forms.Button
   Friend WithEvents Clear As System.Windows.Forms.Button
   Friend WithEvents Fetch As System.Windows.Forms.Button
End Class

Public Class DataForm

   Dim context As SampleDBEntities = New SampleDBEntities()

   Private Sub Save_Click(sender As Object, e As EventArgs) Handles Save.Click
      context.TestDataRTF.Find(1).textvalue = RichTextBox1.Text
      context.SaveChanges()
   End Sub

   Private Sub Clear_Click(sender As Object, e As EventArgs) Handles Clear.Click
      RichTextBox1.Clear()
   End Sub

   Private Sub Fetch_Click(sender As Object, e As EventArgs) Handles Fetch.Click
      RichTextBox1.Text = context.TestDataRTF.Find(1).textvalue
   End Sub
End Class

"This is line 1." + CHAR(13)+CHAR(10) + CHAR(13)+CHAR(10) + "This is line 2."

update TestDataRTF
set textvalue = 'A' + char(13) + char(10) + 'B'
where id = 1

update TestDataRTF
set textvalue = 'A' + char(13) + char(10) + 'B'
where id = 1

Myobject.mytext="This is line 1." + CHAR(13)+CHAR(10) + CHAR(13)+CHAR(10) + "This is line 2."