SPSite rootSite = new SPSite("http://mossvs2008");
SPWeb SubSite = rootSite.AllWebs["LeaveSite"];
string strTitleValue = string.Empty;
Console.WriteLine("Please enter Employee ID");
strTitleValue = Console.ReadLine();
SPList SPList = SubSite.Lists["Employee List"];
SPQuery query = new SPQuery();
query.Query = <Where><Eq<>FieldRef Name='Title' /><Value Type='Text'>"+strTitleValue+">/Value>>/Eq></Where>";>/
SPListItemCollection itemcol = SPList.GetItems(query);
string strTitle = string.Empty;
string strDesignation = string.Empty;
string strEmployeeName = string.Empty;
foreach (SPListItem item in itemcol)
{
strTitle = item["Title"].ToString();
strDesignation = item["Designation"].ToString();
strEmployeeName = item["Employee Name"].ToString();
}
Console.WriteLine("Employee ID.........");
Console.WriteLine(strTitle);
Console.WriteLine("Employee Designation.");
Console.WriteLine(strDesignation);
Console.WriteLine("Employee Name........");
Console.WriteLine(strEmployeeName);
No comments:
Post a Comment