I have a MSIDXS that is returning path and filename.
I don't seem to be able to get the Vpath.
Can anyone suggest why?
<code>
Dim OleDbConnection1 As New System.Data.OleDb.OleDbConnection()
Dim strQuery As String
Dim strCatalog = "TCUSearch"
strQuery = "SELECT FileName, Vpath FROM SCOPE()"
strQuery += " where FREETEXT(Contents, '" & txtSearch.Text & "')"
Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data Source='" & strCatalog & "'"
Dim cn As New System.Data.OleDb.OleDbConnection(connString)
Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)
Dim testDataSet As New DataSet()
cmd.Fill(testDataSet)
Dim source As New DataView(testDataSet.Tables(0))
DataGrid1.DataSource = source
DataGrid1.DataBind()
None
0 Points
51 Posts
MSIDXS not returning Vpath
Dec 05, 2005 10:44 PM|donaldcroswell2|LINK
Hello All
I have a MSIDXS that is returning path and filename.
I don't seem to be able to get the Vpath.
Can anyone suggest why?
<code>
Dim OleDbConnection1 As New System.Data.OleDb.OleDbConnection()
Dim strQuery As String
Dim strCatalog = "TCUSearch"
strQuery = "SELECT FileName, Vpath FROM SCOPE()"
strQuery += " where FREETEXT(Contents, '" & txtSearch.Text & "')"
Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data Source='" & strCatalog & "'"
Dim cn As New System.Data.OleDb.OleDbConnection(connString)
Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)
Dim testDataSet As New DataSet()
cmd.Fill(testDataSet)
Dim source As New DataView(testDataSet.Tables(0))
DataGrid1.DataSource = source
DataGrid1.DataBind()
//Then in my page I display it like this:
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="Filename" HeaderText="FileName"></asp:BoundColumn>
<asp:BoundColumn DataField="Characterization" HeaderText="PATH"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
</code>
Any suggestions why it would show Vpath as empty?
Cheers
Don
Don Croswell
None
0 Points
1 Post
Re: MSIDXS not returning Vpath
Dec 06, 2012 08:03 AM|ghun|LINK
I'm having the same problem. Is there anyone solve this problem?
None
0 Points
27 Posts
Re: MSIDXS not returning Vpath
Jun 10, 2016 05:52 AM|kiquenetavalne|LINK
How can you install MSIDXS ?
any solution about it ?