Get List Items using C#

If we are using SharePoint list as a database then we need to fetch data from list every time so just copy and paste below code with mention parameter it will return you item collection.

Below code is used to get list items based on caml query in SharePoint.

Call GetListItems function with parameters:

1. webUrl: web site url,
2. listName: SharePoint list which contains data
3. query: caml Query
4. viewFields: which fields you want to select.(Use “” if you want to fetch all fields.)

SPListItemCollection coll = GetListItems(webUrl, listName, query, viewFields)
public static SPListItemCollection GetListItems(string sWebUrl, string sListName, string sQuery, string sViewFields)
{
    SPListItemCollection objListItemCollection = null;
    SPSecurity.RunWithElevatedPrivileges(delegate()
     {
        using(SPSite objSite = new SPSite(sWebUrl))
        {
            using(SPWeb objWeb = objSite.OpenWeb())
            {
                SPList objList = objWeb.Lists.TryGetList(sListName);
                if (objList != null)
                {
                    SPQuery objSPQuery = new SPQuery();
                    objSPQuery.Query = sQuery;
                    objSPQuery.ViewFields = sViewFields;
                    objListItemCollection = objList.GetItems(objSPQuery);
                }
            }
        }
    });
    return objListItemCollection;
}