Download files from share point using c#

Question

Hi all, Is it any step by step post or code for download files from folder in sharepoint using c# console application. Thanx in advance.

Thuyavan Ganesan · Answer

Here is the step by step guidance, http://www.thesharepointguide.com/download-file-sharepoint-document-library/ Either you can use with your console app or page code behind,or in event handler, or timer job. I am using this with my event handler .. note : you may run into few authentication prompt. make sure your site is added to the trusted site in the browser

Raghavendar Swaminathan · Answer

Hi Hardik, Hope his would works. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Camelot.SharePointConnector.Data; using System.IO; namespace DownloadDocument { class Program { static void Main(string[] args) { var SPOSPOConnectionString = "Server="";Database=;User=user;Password=password;"; var rootFolder = @"c:documents"; var documents = Helper.ExecuteDataTable("SELECT ServerUrl, Modified, ContentType FROM `libraryname`", SPOConnectionString); if (documents.Rows.Count > 0) { foreach (System.Data.DataRow doc in documents.Rows) { Console.WriteLine(doc["ContentType"] + " " + doc["ServerUrl"]); using (var connection = new SharePointConnection(SPOSPOConnectionString)) { connection.Open(); switch ((string)doc["ContentType"]) { case "Folder": if (!Directory.Exists(rootFolder + doc["ServerUrl"])) Directory.CreateDirectory(rootFolder + doc["ServerUrl"]); break; case "Document": var parentFolder = Directory.GetParent(rootFolder + doc["ServerUrl"]).ToString(); if (!Directory.Exists(parentFolder)) Directory.CreateDirectory(parentFolder); if (!File.Exists(rootFolder + doc["ServerUrl"]) || File.GetLastWriteTime(rootFolder + doc["ServerUrl"]) != (DateTime)doc["Modified"]) { using (var command = new SharePointCommand("CALL DOWNLOAD('Shared Documents', '" + doc["ServerUrl"] + "')", connection)) { var bytes = (byte[])command.ExecuteScalar(); File.WriteAllBytes(rootFolder + doc["ServerUrl"], bytes); File.SetLastWriteTime(rootFolder + doc["ServerUrl"], (DateTime)doc["Modified"]); } } break; } } } } Console.WriteLine("Downloaded"); Console.ReadKey(); } } }

Prashant Kumbhar · Answer

You can also open document library/folder in explorer from which you can directly copy the documents to your machine