Search in Sharepoint List for Listitem

[roopaksr]

I am new to MOSS.

I am seraching in site using search center and Advance Search.

I have a list which have two columns NewsTitle and country (To which news belongs).

When user log in I put his country in session.

Now I want when user searches for news , He will get only those listitem which belongs to his country.

Please let me know how can I achieve this in MOSS.

[bijayani]

The tip below describes the programmatic approach for enabling and disabling Search Visibility of a website in Office Sharepoint Server.The code sample is provide in C#.Net and the keyword "web" refers to the SPWeb object retrieved from a site collection.

/* -- Enable Search -- */
web.AllowAutomaticASPXPageIndexing = true;
web.ASPXPageIndexMode = WebASPXPageIndexMode.Always;
web.NoCrawl = false;
web.Update();

Thanks,
Bijayani
www.mindfiresolutions.com/Sharepoint-Support.htm

[saron]

You should be using a combination of SPQuery (Linq) with CAML, I can't remember exactly where I read it, but I was going through a book that told me that the best way to get data out of a sharepoint list is to use LINQ with CAML.

Also Refer below site.>>http://office.microsoft.com/en-us/windows-sharepoint-services-help/working-with-sharepoint-lists-part-1-HA001119988.aspx