Edit MSSQL table through SharePoint site

[tomash-]

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

[manyag]

Hi

May be you need to write a customized web part for this purpose. As far as I know no Out of box web part supprt data modification in external DB.

Also you should try to see the full error message to get the root cause. The friendly error message does not help much. To turn on the complete error message you need to change entries in web.config. I have put the steps at:

http://manish-sharepoint.blogspot.co...s-in-moss.html

hope this helps
http://manish-sharepoint.blogspot.com

[tomash-]

Thanks for the debugging tip!