I have a standard search bar on my Sharepoint 2007 home page. I have a list with 700+ entries. Each one has a unique ID (auto created). I want to be able to find a specific ID without having to have a catch-all list view and then scrolling down until i find the correct entry.

I am looking for a syntax in can use in the search box ideally that just returns the item i want.

So the problem boiled down is i want a quick way of finding a specific list item

3 Answers
3

There is a Javascript based solution called - instantlistfilter from codeplex. You can use it to filter any column of a list .

I am not sure whether this would satisfy your need, because this way your primary problem of searching from the search box is not solved. But, if this is something which you have not known, check it out.

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.

or the second is to make a custom control within the webpart(if it is that) that contains the creation of SPGridview and databinding.

Have a textbox added to the controls first with a button, then add the SPGridview. When the user searches on the textbox and clicks the button it triggers a clickevent for the button that gets the dataview to get the results but this time it has a new feild that contains the textbox.text instead.... and rebind the result to the gridview. So it would look somthing like this: