Hi,
I made a
program that can add formatted (change font,size and colour) data using a
richtextbox into my MS Access Database,
there is also a normal text box to store the topics which is loaded to a
listbox when you click on a topic in the listbox it is supposed to display the
formatted text in another richtextbox, it displays the plain text perfectly but
as soon as a topic is clicked with
formatted text it displays how the text was formatted:
{\rtf\ansi\ansicpg 1252\deflang7177{\f0\fnil\fcharset
0 Microsoft Sans serif;}}
{\colortbl;\red0\green255\blue128;}
\viewkind4\uc
1\pard\cf1\fs17 now\cf0\par
}
My code:
private void
listItem_SelectedIndexChanged(object sender, EventArgs e)
{
string connstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\Temp\SumWizz.accdb";
OleDbConnection conn = new
OleDbConnection(connstring);
string query = "SELECT
* FROM Items WHERE Name = '" + listItem.Text + "'";
OleDbCommand cmd = new
OleDbCommand(query, conn);
OleDbDataReader reader;
try
{
conn.Open();
reader = cmd.ExecuteReader();
// reads the data and fills the combo box and
listbox
while (reader.Read())
{
string Sdetail = reader.GetString(2);
richItem.Text = Sdetail;
}
}
catch (Exception
ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();
}
I have changed richItem (my richtextbox) to
richItem.rtf = Sdetail;
Then it
displays the formatted text perfectly but when topic selected with plain text
it says format invalid, I have to use it in 2 more places. is there a check I can
do to first check if the text has rtf properties or any other way to get it to
display both plain and formatted text?
Thanks in
advanced
Roelien JoubertPosted Jul 15, 2013, 9:59 AM
Kunal VaishyaPosted Jul 15, 2013, 9:09 AM
richItem.rtf = Sdetail;