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); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)