Searching using Index Server and ASP.NET

Posted on 2004-11-15
Last Modified: 2013-11-25
I'm looking to implement a more robust search engine on an existing ASP.NET app. The application allows uploading of documents (word, excel, etc) and stores the files on a directory, and also inserts a row into SQL Server table, lets call the table 'files'. it stores information about the documents such as filesize, type, filename, etc.

My question is.... using Index Server (which I  have not had the pleasure of doing up till now) will it be possible to query the Index Server catalog thru a SQL stored procedure, and do a JOIN on other tables (ie my 'files' table.) to check for permissions, etc

For instance, (pseudo code)
SELECT something FROM IndexServerCatalog as ISC on blah blah..
JOIN FILES as F on ISC.DocumentTitle = F.DocumentTitle AND F.CreatedBy = @CreatedBy

Question by:Rodney Helsens
    LVL 25

    Expert Comment


    Have a look at the following MS Howto:

    Title: HOW TO: Use an ASP.NET Application to Query an Indexing Service Catalog by Using Visual Basic .NET

    HTH, Nauman.
    LVL 9

    Author Comment

    by:Rodney Helsens
    nauman, thanks for the link, I had seen this KB article already. I am really trying to determine how it would be possible to perform a JOIN on the results. This question may be more suited to the SQL Server area.

    My scenario is. I want to be able to apply my own SQL based permissons to the Index Server results..

    User A has permissions to see documents 1,2 and 3...

    User A searches the Index Server catalog but only return results which he has permissions to view. I considered passing this (@Docs = '1,2,3') as a param to the IndexServer query..but in reality, the user could have permissions on 1,000's of documents, so thi would seem less than ideal.

    So I was wondering if it was possible to somehow JOIN the results from IndexServer search with the permssions table in my application database.

    Any ideas appreciated..
    LVL 6

    Expert Comment

    by:Duane Lawrence
    LVL 6

    Expert Comment

    by:Duane Lawrence
    I found something better

    LVL 6

    Accepted Solution


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
    For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now