I have a listview binded from a sql DB table with column1, column2, column3, I want to copy all the listview items in a sharepoint 2010 list column1, column2, column3 programmatically PS : sharepoint list have additional columns: column4, column5 and in the listview items are refreshed so when an item is deleted from listview it have to be deleted from the list too. I m gathering some idea, if it's feasable or not thanks
You can create an External Event Receiver. That basically monitors external objects in your case its a SQL DB Table.
Inside the event receiver you can write code using SharePoint Object Model to Add/Update/Delete corresponding List Items.
Update - Above is valid only for SP 2013 and above
For SharePoint 2010 you are only option seems polling the SQL table in regular intervals and looking for changes. This will be tedious process because you don't know which item got changed. Polling logic can be done in a SharePoint custom Timer Job.
You can enhance performance by adding a last modified field in your SQL table and use that to sync between SPList and SQL Table.