How to read SharePoint Data and insert into SQL

Question

need to read share point list and inser into sql table

Pandurang Somwanshi · Answer

Thanks Jithu Thomas As you suggested i have tryed and it is working

Jithu Thomas · Answer

Install Required Libraries : You will need to install the necessary libraries for SharePoint connectivity and SQL Server connectivity in your C# project. These libraries can be added through NuGet if they are not already included: Microsoft.SharePoint.Client: for SharePoint connectivity. System.Data.SqlClient: for SQL Server connectivity. Connect to SharePoint: Connect to your SharePoint site using the SharePoint Client Object Model. Here's a basic example of how to establish a connection: using Microsoft.SharePoint.Client; string siteUrl = "https://your-sharepoint-site-url"; string username = "your-username"; string password = "your-password"; using (ClientContext context = new ClientContext(siteUrl)) { context.Credentials = new SharePointOnlineCredentials(username, Utilities.CreateSecureString(password)); // Perform SharePoint operations here } Read SharePoint Data: Use the SharePoint Client Object Model to retrieve the data you need from SharePoint. This can involve fetching lists, items, or documents, depending on your requirements. List spList = context.Web.Lists.GetByTitle("YourListName"); CamlQuery query = CamlQuery.CreateAllItemsQuery(); ListItemCollection items = spList.GetItems(query); context.Load(items); context.ExecuteQuery(); foreach (ListItem item in items) { // Extract data from SharePoint item string columnValue = item["ColumnName"].ToString(); // Insert this data into SQL Server } Connect to SQL Server: Establish a connection to your SQL Server database, as described in the previous answer. Insert Data into SQL Server: Use SQL commands to insert the data retrieved from SharePoint into your SQL Server database. You can use parameterized queries to ensure data integrity and security. string sqlConnectionString = @"Server=YourSqlServer;Database=YourDatabaseName;Integrated Security=true;"; using (SqlConnection sqlConnection = new SqlConnection(sqlConnectionString)) { sqlConnection.Open(); // Inside the SharePoint data retrieval loop string insertQuery = "INSERT INTO YourTableName (Column1, Column2, ...) VALUES (@Value1, @Value2, ...)"; using (SqlCommand insertCommand = new SqlCommand(insertQuery, sqlConnection)) { insertCommand.Parameters.AddWithValue("@Value1", columnValue1); // Use SharePoint data insertCommand.Parameters.AddWithValue("@Value2", columnValue2); // Use SharePoint data // Add parameters for all columns in your table insertCommand.ExecuteNonQuery(); } } Close Connections: Make sure to close both the SharePoint and SQL Server connections when you're done.

How to read SharePoint Data and insert into SQL

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)