A time in the format hh:mm:ss will parse into a date as today's date plus the parsed time. So 17:10:03 would parse as April 27, 2010 5:10:03 PM.
With that in mind, you would be able to simply do a straight comparison of your parsed time value and the currrent date and time.
As for conversion methods, I would recommend DateTime.TryParse(input, out result) on your string.
string input = "17:10:03";
if (DateTime.TryParse(input, out userTime))
// compare user time to datetime.now
// invalid input
As a side note, I didn't expect that behavior on the parsing of a time sans a date. I expected it to be something like "1/1/0001 5:10:03 PM." But I've tested and got the same unanticipated behavior in C# 3 and C# 4. I assume there's some documentation out there, but I have not conducted a proper search.
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...