C#向SQLserver插入rtf格式文本的方法

写入

  MemoryStream ms = new MemoryStream();
            richtxt_jcms1.SaveFile(ms, RichTextBoxStreamType.RichText);
            Byte[] bt = ms.ToArray();
            string rtfText;
            rtfText = Encoding.ASCII.GetString(ms.ToArray());
SqlCommand cmd = new SqlCommand("update [template5] set examDesc=@examDesc WHERE template_id = @template_id");
            cmd.Connection = conn;
            cmd.Parameters.AddWithValue("examDesc", rtfText);
            cmd.Parameters.AddWithValue("template_id", id);
            cmd.BeginExecuteNonQuery();
            System.Threading.Thread.Sleep(500);
            conn.Close();

向richtextbox写入rtf文本

 string rtfText = ds.Tables[0].Rows[0]["examDesc"].ToString(); //string from db
                    if (rtfText != "")
                    {
                        byte[] byteArray = Encoding.ASCII.GetBytes(rtfText);
                        MemoryStream ms = new MemoryStream(byteArray);
                        richtxt_jcms1.LoadFile(ms, RichTextBoxStreamType.RichText);
                    }