How to fetch the value of a column from a sharepoint list

Question

How to fetch the value of a column from a Sharepoint list using C# code.

Shuvojit Halder · Answer

SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite spSite = new SPSite(SPContext.Current.Web.Url)) { using (SPWeb spWeb = spSite.OpenWeb()) { try { spWeb.AllowUnsafeUpdates = true; SPList splist = spWeb.Lists[Your list]; SPQuery myquery = new SPQuery(); myquery.Query = ; SPListItemCollection items = splist.GetItems(myquery); foreach (SPListItem item in items) { //Your items } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } } } });

Shweta Lodha · Answer

May be below snippet taken from MSDN will help you: using (SPSite siteCol = new SPSite( http://server/sites/Contoso )) { using (SPWeb web = siteCol.RootWeb) { SPList list = web.GetList( /sites/Contoso/Lists/Books ); SPListItem item = list.GetItemByIdSelectedFields(3 Title  ISBN  Retail_x0020_Price ); String bookISBN = (String)item[ ISBN ]; } }