title: Storing data of rich text box to database with formatting
body: <p>I am new at wpf and I want to store the data of the rich text box along with its formatting (Italic, colored, Bold..)  into a database (Mysql).
  currently when i save the data, formatting is ignored. 
  in addition, it shows all the text in the same line when i load it back to the rich text box from the database. 
  Looking forward to your help and suggestions!</p>
  
  <pre><code>public void save()
      {  
  
          MySqlConnection conn = new MySqlConnection(connString);
          MySqlCommand command = conn.CreateCommand();      
          string richText = new TextRange(rt1.Document.ContentStart,  rt1.Document.ContentEnd).Text;
  
          string s = WebUtility.HtmlEncode(richText); 
          command.Parameters.AddWithValue("@s", s);           
          command.CommandText = "insert into proc_tra (procedures) values (@s)";
          conn.Open();
          command.ExecuteNonQuery();
          conn.Close();
      }
  
  public void load()
  
      {   MySqlConnection conn = new MySqlConnection(connString);
          MySqlCommand command = conn.CreateCommand();
          command.CommandText = "select * from proc_tra where id_pt=4";
          rt1.Document.Blocks.Clear();            
          conn.Open();            
          MySqlDataReader dr;
          dr = command.ExecuteReader();
          string k="";           
          while (dr.Read())
          {              
              k += dr["procedures"].ToString();
          }
          var p = new Paragraph();
          var run = new Run();
          run.Text = WebUtility.HtmlDecode(k);
          p.Inlines.Add(run);
          rt1.Document.Blocks.Add(p);
      }
  </code></pre>