SharePoint University

Hello!

I'm new to SharePoint and ASP.NET.
I want to connect to and edit an SQL Server 2005 database through a sharepoint server 2007 site.
My question is:
What would be the simpliest way to do this?
I'd like to have a simple a grid view of a table on the site so that the table can be changed through the view.

With Sharepoint designer i've created a site containing an ASP.NET GriedView with the proper data source, with SQL Authentication. And it all works fine except that I can't edit the table through the sharepoint site.
Is there any SharePoint or ASP.NET Control which can do this just like if I was editing the table?

One solution would be to use the AutoGenerateEditButton of the GridView, but that wouldn't be a comfortable way to work with the table.
(and it didnt work for me, when I wanted to update something this error occured: An unexpected error has occurred. :) 

Thanks a lot for your help!

Tom

That's the "hard" way. SharePoint and SharePoint Designer's Data View/Data Form web part can do what you want. There is a little configuration you need to do first.

In Central Administration, go to the Operations Tab, and the Data Retrieval Service settings. Change either the global settings (if appropraite) or the settings for your web application to have the "Enable Update Query Support" checked.

Then, From the Data menu in SharePoint Designer, manage data sourced, and configure a Data Source to point at your database table.

Open a web part page, and insert a data view web part. On the data view properties dialog, enable the editing controls you want.