Advertisement
Guest User

Untitled

a guest
Aug 30th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. using (SPWeb oWeb = siteh2.OpenWeb())
  2. {
  3.  
  4. //SPWeb oWeb = SPControl.GetContextSite(Context).OpenWeb();
  5. SPList oList = oWeb.Lists[theList];
  6.  
  7. SPQuery oQuery = new SPQuery();
  8. oQuery.Query = "<Where><Eq><FieldRef Name='" + matchColumnName + "' />" +
  9. "<Value Type='Text'>" + valueToMatch + "</Value></Eq></Where>";
  10.  
  11. //oQuery.Query = "<Query><Where><Eq><FieldRef Name='Username' /><Value Type='Text'>whelanp</Value></Eq></Where></Query>";
  12.  
  13. SPListItemCollection results = oList.GetItems(oQuery);
  14.  
  15. if (results.Count == 0)
  16. return "";
  17.  
  18. foreach (SPListItem oListItem in results)
  19. {
  20. return cleanValue(oListItem[returnColumnName].ToString());
  21. }
  22.  
  23. return "";
  24.  
  25. }
  26. }
  27. catch (Exception ex)
  28. {
  29. return "";
  30. }
  31.  
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement