Hi everyone...

i have to load 2 different text(paragraph) from database to a control(panel or label).Then i shud compare and highlight the similar words in the two controls which is loaded.

please suggest me...how to do it...which control shud i use for loading text.How do i compare and highlight the similar words with colors????

please give a idea on this....this comparison shud be done in webpage.

Thanks in advance....

Karthik
[Nothing is impossible]

__________________
Karthik
[Nothing is impossible]

Seems fairly easy enough. Really depends on how you want to highlight the output text.

I'd use Scalars to get the two values:

Dim SQLConn as SQLConnection, Text1 as string, Text2 as string
Dim SQLGet as SQLCommand
SQLConn = New SqlConnection("Server=<insert server>;Database=<insert Dbase>;Integrated Security=SSPI;MultipleActiveResultSets=True")
        SQLConn.Open()
        SQLInsert = New SqlCommand("SELECT field1 FROM someTable", SQLConn)
        Text1 = SQLInsert.ExecuteScalar
SQLInsert = New SqlCommand("SELECT field2 FROM someTable", SQLConn)
        Text2 = SQLInsert.ExecuteScalar
        SQLConn.Close()

Now your variables Text1 and Text2 have the two fields.

Then, I'd Dim out a couple of string arrays, split on the space to pull back individual words and loop though them

Dim strText1() as string, strText2() as string
strText1 = Text1.Split(" ")
strText2 = text2.split(" ")

For X as integer = Lbound(strText1) to Ubound(strText1)
if strText1(x) = strText2(x) then
Console.WriteLine(strText1(x) & " matched")
else
Console.WriteLine(strText1(x) & " did not match")
end if
Next


Making it highlight from there would be easy enough.



--Ryan Campbell
ryan@extremewebguy.com

If you are going to high light similar words in colors then you are going to have to use the RichTextBox control, as its the only built in control that can have different colored text in the same box.

And it greatly depends on what you mean by 'similar words' as to how you would do the second part. An example of some input paragraphs and expected outputs would help.

/- Sam Judson : Wrox Technical Editor -/