Approving articles to be the replicated to the SQL table
Sharepoint supports complex approval procedures based on workflows that can be customized to satisty very specific needs. In our case however, we are only going to use the built-in "Content Approval" feature where - granted the correct permissions on the List - it is a one-step process.
7.1 for each of the the "News Articles" list items, open the context menu and select you will be presented with the form where all needs to be done is check the option and click the button. The screenshots below shows this process.
Important: Note that, when you modify a Sharepoint list item that has been previously approved, you will have to approve the item again in order to have your changes published on to the SQL database.
7.2 Here are our articles in the SQL table.
From this point on, SQList will keep the SQL table synchronized with the Sharepoint list (data and structure). Now we can write some simple code to display the articles form the Sharepoint list on a webpage.
