MSIDXS not returning Vpath RSS

• • Reply
  

  donaldcroswe...

  Member

  305 Points

  61 Posts

  MSIDXS not returning Vpath

  Dec 06, 2005 02:44 AM|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

  Cheers
  Don Croswell
• • Reply
  

  ghun

  Member

  2 Points

  1 Post

  Re: MSIDXS not returning Vpath

  Dec 06, 2012 12:03 PM|LINK

  I'm having the same problem. Is there anyone solve this problem?