Hot answers tagged development
First one is wrong, because you can have only one Value child in Eq element. Second one is wrong, because you put your desired values in Type attribute. You've used correct syntax in first one: <Value Type='Text'>Ordered</Value> So the correct query is: <View><Query><Where><In><FieldRef ...
I recommend you start with this book, "Inside Microsoft SharePoint 2010". The first 4 chapters can be read online at MSDN this link: Book landing page: Inside Microsoft SharePoint 2010
You can use: string value = (new SPFieldLookupValue(item["FieldName"] as String)).LookupValue
Only top voted, non community-wiki answers of a minimum length are eligible