Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / fetch record from sharepoint online to sql server
Ask Question
Satyaprakash Samantaray
Satyaprakash Samantaray

Other

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

Message

1 Answers

Prakash nidhi Verma
Prakash nidhi Verma 07 Jun 2018
Report Abuse

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 :)

MindStick Training