richTextbox change colors for words

Question

Hello I have a code thats changes colors for special words and sets brackets for sql query. But I have problem whan I press button it's makes all text blue. I type a same code in richtextbox like this: select aaa from bbb where a=1 or a=2 or a=3 and b=2 or b=3 and c=2 or c=3. It's make words colored like 'select from where and or to' color blue. Can someone tell me why it's color all text blue after I press button and program adds brackets ? Here is my code: http://paste.php.lv/7cd1b3da1717783542b2a414d73a1e30?lang=csharp

Frogleg · Answer

I put this in the button to add brackets HighlightPhrase(richTextBox1richTextBox1.TextColor.Black); and then called the method to color the text again

Janis Peksa · Answer

O thanks it worked very good for me ;)

Janis Peksa · Answer

Yes I tried something like that but it's not working. I don't know how to change all text to black. And send send my method again. I tried like this: richTextbox1.ForeColor = Color.Black; But nothing happends. Maybe you know how to change all text to black ?

Frogleg · Answer

If you put the code from richTextBox1_TextChanged into it's own method then after inserting brackets change all richTextBox1.Text to black and then call richTextBox1_TextChanged code. It's a work around. Without knowing the full string I'm only guessing

Janis Peksa · Answer

No I need it on TextChange. Did you try my code and see the problem ?

Frogleg · Answer

When you click to add brackets can't you change text color then ?

Janis Peksa · Answer

Okey I puted in TextChange. It's works 50/50. Selects word and color it and stay selected I don't need it to be selected. Try my code and you will see what I need. And you will see what problem I have.

Frogleg · Answer

It may not work because the strings don't match - It is working perfectly in my sample project put highLightTextBlue(Select); highLightTextBlue(where); highLightTextBlue( or); in richTextBox1_TextChanged event once you type last letter it should change text color as required

Janis Peksa · Answer

First of all your code doesn't work :( And I need on TextChange event not on click event. My code works fine with text color change. But whan I press button it's adds brackets where needed but makes all text blue why ? :( Maybe someone can show me how to make it right ?

Frogleg · Answer

Try this private void button1_Click(object sender EventArgs e) { highLightTextBlue(Select); highLightTextBlue(where); highLightTextBlue( or); } public void highLightTextBlue(string wh) { int stIndex = 0; stIndex = richTextBox1.Find(wh stIndex RichTextBoxFinds.MatchCase); while (stIndex != -1) { if (richTextBox1.SelectedText == wh ) { richTextBox1.SelectionLength = wh.Length; richTextBox1.SelectionColor = Color.Blue; } stIndex = richTextBox1.Find(wh stIndex + 1 RichTextBoxFinds.MatchCase); } } Note = only blue text changed - you will have to create a method for other colors