I have a custom list that contains a row of data. The data in the list is created from the data in the table in the SQL table. I need to check the data in database table and the data in the list is same in the load event of the ist and if it is not make it updated in the list as it is in the sql table. How can i impliment this?
You can write Event Receiver and on ItemAdding event, check what you need...
But why you are duplicating data in SQL Table and SharePoint List... Is that a necessity? Are you aware of External Content Types and Business Connectivity Services [if using SharePoint Enterprise]