How to fetch data from sharepoint online to sql server table using windows console application ?
Please share code sample....
How to fetch data from sharepoint online to sql server table using windows console application ?
Please share code sample....
Other
MVP Award Winner | Community Author | S/W Developer & Programmer | Blogger | Community Award Winner | Most Valuable Blogger(MVB)
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 :
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 :)