updating SPColumn


I have a Sharepoint list and value for one of its columns is Sum of two columns of SQL Server table , the values in SQL table are subjected to change from other source.

Now my question is what is the right way of updating the column value from the SQL Table in timely manner.

Who is Participating?
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
data view web part.  this web part is used to display data from SQL.  it will show the change immediately.

this article has a lot of info about DVWP:

one way to use DVWP is to add it to a page using sharepoint designer.  it's easy to configure the data source to point to sql.
All Courses

From novice to tech pro — start learning today.