This is pretty basic information, but I had trouble finding a simple code snippet outlining how this works. Here is super short snippet that finds and opens a file by its Title field.
This is pretty basic information, but I had trouble finding a simple code snippet outlining how this works. Here is super short snippet that finds and opens a file by its Title field.
//Begin by opening your List  
 SPList docList = web.Lists[“Requests”];
//Build your query. In this example, fileName is the name of a file we’re already saved to the list  
 SPQuery query = new SPQuery();  
 query.Query = “<FieldRef Name=’Title’ />” + fileName + “”;
//Now use your query to pull all the matching documents from our list.  
 SPListItemCollection listItemColl = docList.GetItems(query);
//In this example, we’re assumign that we’ll always only get a single document back.  
 //In practice, you should check listItemColl.Count to ensure that you’re finding the doc.  
 SPListItem listItem = listItemColl.List.Items[0];The meat of the snippet is the Query string: <FieldRef Name=’Title’ />” + fileName + ”
I’d highly recommend downloading U2U’s CAML Builder to simplify building your query. Just remember to strip out the tag U2U’s tool likes to insert.
