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.