Download files from share point using c#

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 

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();

}

}

}