How to update a table in SQL-server from sharepoint

How can I easy connect a table in SQLserver to sharpoint to view and update.
Is it a special webpart for that or can I do it in a list.
I read about SharePointRS.msi do I need to install that? and where? on the
sharepoint webserver or on the sharpoint SQL server.

Lennart

Evren
Sat Feb 09 12:29:01 CST 2008

You can write a custom webpart to do it, then package it and register as
feature. If you want to view table items such as Sharepoint list, use SPGrid
control to visualize.

"Lennart" wrote:

> How can I easy connect a table in SQLserver to sharpoint to view and update.
> Is it a special webpart for that or can I do it in a list.
> I read about SharePointRS.msi do I need to install that? and where? on the
> sharepoint webserver or on the sharpoint SQL server.
>
> Lennart