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