richtextbox 中每个单词的额外信息 - richtextbox 和 sql 表之间的链接

Question

我有一个 Richtextbox，它的文本是特定表中一些单词的串联。 （表列是“单词”、“翻译”和“id”）

我需要当用户将鼠标悬停在每个单词上时，相关的翻译会显示在单词的工具提示中。 （类似于谷歌翻译，但在 Windows 窗体应用程序中。）

有人可以指出我的解决方案吗？

Answer 1

使用 Web 浏览器控制和注入 JavaScript 解决了我的问题。 ;)

Answer 2

这就能解决问题...

private void richTextBox1_MouseMove(object sender, MouseEventArgs e)
{
     // whitespace definition
     char[] whitespace = new char[] { ' ', '\r', '\n', '\t' };

     int charPosition = this.richTextBox1.GetCharIndexFromPosition(e.Location);

     string fullText = this.richTextBox1.Text;

     // if we are on whitespace, exit
     if (whitespace.Contains(fullText[charPosition]))
     {
         return;
     }

     // find a whitespace towards the start of the text
     int firstWhiteSpace = charPosition;
     while (firstWhiteSpace > 0
         && firstWhiteSpace < fullText.Length
         && !whitespace.Contains(fullText[firstWhiteSpace]))
     {
         firstWhiteSpace--;
     }
     if (firstWhiteSpace!=0)
         firstWhiteSpace++;
     // find the next whitespace
     int lastWhiteSpace = fullText.IndexOfAny(whitespace, charPosition);
     if (lastWhiteSpace == -1)
         lastWhiteSpace = fullText.Length;

     // substring the word out of the flat text
     string word = fullText.Substring(
         firstWhiteSpace, 
         lastWhiteSpace - firstWhiteSpace);

     // show the result
     label1.Text = String.Format("pos:{0} fsp:{1}, lsp:{2}, len:{3}, word:{4}", 
         charPosition, 
         firstWhiteSpace, 
         lastWhiteSpace, 
         fullText.Length, word);

 }

Answer 3

我对 C# 不太熟悉，而且我也是这个论坛的新手。然而，在我看来，如果你用一个函数来补充 rene 发布的代码，该函数查询你的翻译表并返回翻译文本，那么你就会得到这个（原谅我的伪代码屠杀 - 我对 vb 非常流利）。 net，很快就会学习 C# 语法）：

Private String TranslatedWord(ByVal SelectedWord String)
    {
        //Use ADO and SQL to retrieve the Translation(s) associated with the submitted Word

        // A string SQL Statement (the GROUP ON is in case there are multiple instances of the same word, with different translations (synonyms). THis SQL Should return a a single record for each possible translation of the submitted word (more than one result possible):
            Dim SQL as String = _
            "SELECT tr.ID, tr.Translate " & _
            "FROM MyTranslationTable AS tr " & _
            "WHERE tr.Word LIKE @Word"

        //Since I could be ALL DAY struggling to write the C# code for this, I will just step through it in "pseudocode": 
        // 1. Execute the SQL using ADO.Net, set up the @Word Param in your command, and return a sqlDataReader
        // 2. Iterate through the returned records, and append the Translation results to a System.Text.Stringbuilder object. Delimit each returned value with a semi-colon (or your delimiter of choice). 
        // Return the Stringbuilder.ToString property as the result of this function;

}

然后按如下方式更改 rene 代码的最后一部分（“//显示结果”）（适合纠正我可怕的 C# 问题！）：

        private void richTextBox1_MouseMove(object sender, MouseEventArgs e)                                        
    {                                             
        // whitespace definition                                             
        char[] whitespace = new char[] { ' ', '\r', '\n', '\t' };                                                                                     
        int charPosition = this.richTextBox1.GetCharIndexFromPosition(e.Location);                                                                                     
        string fullText = this.richTextBox1.Text;

        // if we are on whitespace, exit                                             
        if (whitespace.Contains(fullText[charPosition]))                                             
        {                                                 
            return;                                             
        }                                                                                     
        // find a whitespace towards the start of the text                                             
        int firstWhiteSpace = charPosition;                                             
        while (firstWhiteSpace > 0                                                 
            && firstWhiteSpace < fullText.Length                                                 
            && !whitespace.Contains(fullText[firstWhiteSpace]))                                             
            {                                                 
            firstWhiteSpace--;                                             
        }                                             
        if (firstWhiteSpace!=0)                                                 
            firstWhiteSpace++;

        // find the next whitespace                                             
        int lastWhiteSpace = fullText.IndexOfAny(whitespace, charPosition);                                             
        if (lastWhiteSpace == -1)                                                 
            lastWhiteSpace = fullText.Length;

        // substring the word out of the flat text                                             
        string word = fullText.Substring(                                                 
            firstWhiteSpace,                                                  
            lastWhiteSpace - firstWhiteSpace);  

        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
        //My CHanges start here, and will likely require 
        // some tweaking . . .

        //Use the function I have poorly described above to retreive the 
        //translation(s) for the current Word:
        string TRANSLATION = TranslatedWord(word);                                                         

        // show the result     
        //Since there are so many minor but important differences between C# and VB, I am not going to attempt
        //to account for them. Essentially, display the translated word instead of the word over which the mouse is hovering:                
        label1.Text = String.Format("pos:{0} fsp:{1}, lsp:{2}, len:{3}, word:{4}",                                                  
            charPosition,                                                  
            firstWhiteSpace,                                                  
            lastWhiteSpace,                                                  
            fullText.Length, TRANSLATION);      

    }

如果有帮助，我可以崩溃相当快地给出了 vb.net 代码，但除非有帮助，否则我不会这样做。

希望这有帮助。我将不得不努力学习 C#，并提高我对在这个论坛上发帖的理解！让代码看起来正确是一个挑战。 。 。