forum

Home / DeveloperSection / Forums / Fetch record from sharepoint online to sql server

Ask Question

Fetch record from sharepoint online to sql server

Satyaprakash Samantaray 1507 25-May-2018

How to fetch data from sharepoint online to sql server table using windows console application ?

Please share code sample....

database sharepoint  sql server 2012 
Updated on 07-Jun-2018
Satyaprakash Samantaray

Satyaprakash Samantaray

Follow
MVP Award Winner | Community Author | S/W Developer & Programmer | Blogger | Community Award Winner | Most Valuable Blogger(MVB)

Can you answer this question?

Answer

1 Answers

Prakash nidhi Verma

Prakash nidhi Verma

07-Jun-2018

You should use of microsoft.sharepoint for access data into a datatable for easy calling by using this below class. 

Method for calling into Database :  

DataTable x = new DataTable(); 
x = ClassName.GetList("http://your site URL", "List table name");

Fetching data in DB from console application and create a new new list item by this below code : 

Clientdata data = new Clientdata Data("http://SiteUrl");  
//list name "mindstick"

List mindstickList = data.Web.Lists.GetByTitle("mindstick"); 

// creating a regular list item

ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); 

ListItem newItem = mindstickList.AddItem(itemCreateInfo); 

newItem["Title"] = "Unleash your Imagination"; 

newItem["Body"] = "Software Development"; 

newItem.Update(); 

mindstick.ExecuteQuery();

I hope ,It would be helpful for you..

Happy Coding :)

Liked By