Sharepoint Asp.net Integration using Client

If we want to fetch data from sharepoint and use it in .net Application(Web App or Win App)

The steps are as under…

Earn upto Rs. 9,000 pm checking Emails. Join now!

1. Copy three dll files in the Application
   
   1. Microsoft.Sharepoint.dll
      
   2. Microsoft.Sharepoint.Client.dll
      
   3. Microsoft.Sharepoint.Client.Runtime.dll
      
2. Add the reference of these three files to the Application
   
3. Add the function for the Data AccessLayer
   (This Code is for getting all categories)
   
   1. 
      public
      ListItemCollection GetAllCategory()
      
   2. {
      
   3. 
      List resultlist = null;
      
   4. 
      ListItemCollection items = null;
      
   5. 
      //List<Category> resultList = new List<Category>();
      
   6. 
      //Category category = null;
      
   7. 
      try
      
   8. {
      
   9. 
      string webUrl = "http://domain:port";
      
   10. 
       NetworkCredential credentials = new
       NetworkCredential("UserName", "Password", "Domain");
       
   11. 
       using (var clientContext = new
       ClientContext(webUrl))
       
   12. {
       
   13. clientContext.Credentials = credentials;
       
   14. resultlist = clientContext.Web.Lists.GetByTitle("Categories");
       
   15. 
       StringBuilder query = new
       StringBuilder();
       
   16. 
       
   17. query.Append("<View />");
       
   18. 
       CamlQuery caml = new
       CamlQuery();
       
   19. caml.ViewXml = query.ToString();
       
   20. 
       
   21. items = resultlist.GetItems(caml);
       
   22. clientContext.Load(items);
       
   23. clientContext.ExecuteQuery();
       
   24. }
       
   25. }
       
   26. 
       catch (Exception exception)
       
   27. {
       
   28. 
       Console.WriteLine(exception.Message);
       
   29. 
       
   30. }
       
   31. 
       return items;
       
   32. }
       
4. Add the function for the Business Layer
   (This Code is for getting all categories)
   
   1. public
      List<Category> GetAllCategory()
      
   2. {
      
   3. 
      List<Category> lstctg = new
      List<Category>();
      
   4. 
      CategoryDataAccess CDA = new
      CategoryDataAccess();
      
   5. 
      try
      
   6. {
      
   7. 
      ListItemCollection lst = CDA.GetAllCategory();
      
   8. 
      
   9. 
      foreach(ListItem item in lst)
      
   10. {
       
   11. 
       Category ct = new
       Category();
       
   12. ct.CategoryId = item.Id;
       
   13. ct.Description = item["Description"].ToString();
       
   14. ct.Title = item["Title"].ToString();
       
   15. lstctg.Add(ct);
       
   16. }
       
   17. 
       return lstctg;
       
   18. }
       
   19. 
       catch (Exception ex)
       
   20. {
       
   21. 
       throw ex;
       
   22. }
       
   23. }
       
5. This will generate the List of Entities(Category) and return to the view Layer
   
6. This functions explain how to set the authority for the sharepoint site.