After days of searching for a solution on the Internet I hope someone can help, Others have had the same problem but there were no real solutions posted.
My problem is that the Index Service does not return all the fields in the results of my DataGrid, for example DocTitle and Characterization are empty while Path and Url bring back entries. If I use the Indexing services default query page for that catelog it returns all the correct information. I dont believe its my code because its pretty much the same as all the examples I have found on the net. It does not matter if I use the existing 'Web' catelog or create my own.
Hope someone has a suggestion.
Dim strQuery As String
strQuery = "Select DocTitle,Path,url,Characterization from SCOPE() where write_ > '2000/06/26' and CONTAINS(filename, '.htm')"
Dim connString As String = "Provider=MSIDXS;Data Source=web"
Dim cn As New System.Data.OleDb.OleDbConnection(connString)
Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)
Dim testDataSet As New DataSet("results")
Dim source As New DataView(testDataSet.Tables(0))
DataGrid1.DataSource = source
View Complete Post