VB.Net OleDb Update with text RTF


How do I update a database from my Rich Text Box?

Atm I have:
.Parameters(9).Value = frmEditor.txtLyrics.Rtf

I know how to run the update statement, just what I have so far only updates the field to contain:
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Impact;}{\f1\fswiss\fcharset

What am I doing wrong?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

What you are seeing is the RTF encoding of your RichTextBox, taken from the RTF member of RichTextBox. This is what makes the box display all of the pretty colors and fonts. You can upload the Text member of the RichTextBox, but you will lose all of the formatting (the aforementioned colors and fonts) if you do. That is to say you will ONLY get the text contained within the box.
LetsgetcodingAuthor Commented:
I see.

So how do I do it so I can keep both the formatting and text?
The text is in your database--it is just mixed in with the RTF code. Dump the field out from the database to a text file and you will see the text if you scroll far enough to the right  :)
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Think of it similar to HTML--your text is mixed in with HTML tags. The tags just specify how the text should be displayed. The same is true of RTF.
LetsgetcodingAuthor Commented:

I copied the whole field out and pasted it in a text document, and this is all the came out:
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Impact;}{\f1\fswiss\fcharset
Perhaps the size of your column is truncating the remaining text?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LetsgetcodingAuthor Commented:
Why did I not see that.

.Parameters.Add("@Lyrics", OleDb.OleDbType.VarChar, 100)

Haha, such a rookie mistake!

Thanks for that kaufmed!
NP. Glad to help  :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.