I am developing a site using Asp.net 2.0   Web Parts and this site would be hosted on IIS 6.0. Users of the site can freely add/edit content to the pages and this content is stored using personalisation by the ASP.NET Application service provider.

Now the problem is how to index this content, so that the users can conduct searches on the site content. If anyone can suggest how to do this, it would be very helpful.

Hi,

Solution: 

What I recommand is to expand the Personalization table which webpart uses because you have used webpart already, so the user authority mechanism (including datatable: aspnet_PersonalizationPerUser, aspnet_PersonalizationAllUsers) works and there's no need to create another one. So the thing is just to create a content field in personaliztion tables and when the user has changed the content, save it into the tables according to the user id.

Notice:

In your question you mentioned the user of the site can freely add/edit the content. So the problem is if the relationship between user and content is 1 to 1 or 1 to multiple. If 1 to 1, there's no action needed. If 1 to multiple, what I think is to use some specific char to isolate each of the content and save them in one field.(Don't use multiple rows in personalization table,otherwise it doesn't obey the original table's structure.) When reading the content from the table, you also can use split method to get each content of the user.

Thanks.

Nai-Dong Jin - MSFT:

What I recommand is to expand the Personalization table which webpart uses because you have used webpart already, so the user authority mechanism (including datatable: aspnet_PersonalizationPerUser, aspnet_PersonalizationAllUsers) works and there's no need to create another one. So the thing is just to create a content field in personaliztion tables and when the user has changed the content, save it into the tables according to the user id.

Thanks for the reply.

I have one last doubt. I  think that, the way you propose involves, implementing a custom personalization provider or is there a way to do it with the existing providers itself. Please clarify.

Hi there!,

i came up with your very same problem, how did you sort it out?

did you just implemented a new parameter in the save?, that looks like an appropiatte one, but......

how do you query them when actually searching?

for efficiency's sake, have you thought of creating your own indexin system..lets say everytime you save the webpart insert or update some other table you created with your possible query tags + the pathId

Hello,

Well what I am doing is, when the User hits search, I screen scrape all the pages,  get the page content and using reg exp generate my search results, works like a charm and is quite efficient too, not at all as slow as I hoped it would be (maybe its coz i have very less number of pages about 40 to 50)

thats ok, i mean the number of pages.

but when you say : 'screen scrape all the pages' Do you mean actually read out all content, or you taken the keywords aproach?.

Sorry i am borthering you. what i am after is the same funcionality like the tags in this very forum.

Hey no probs man, always glad to help,

Well I am not following the keywords approach, coz our content is totally dynamic, users can practically enter anything they want, so as i mentioned , I scrape the pages, get the page content and then sift through them for the search criteria and this happens at runtime.

If you want to follow the keywords approach, what you can do is implement your own personalization provider and create functionality to map each url with a set of keywords. 

I hope that helps, in case of any doubts dont hesitate to ask