70-541: Create a custom SPQuery object.

using (SPSite spSite = new SPSite("http://testsite/"))


{

using (SPWeb objWeb = spSite.OpenWeb())

{



SPList objList = objWeb.GetList(objWeb.Url + "/Lists/" + "ListName");



SPQuery query = new SPQuery();

query.RowLimit = 10;

query.Query = "<Where><Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">" + "Samarendra" + "</Value></Eq></Where>";

SPListItemCollection itemColl = objList.GetItems(query);

if (itemColl.Count > 0)

{

SPListItem lstItem = itemColl[0];

}

}

}