I would like to manipulate an sql table via web interface in sharepoint the same way I use datasheet view for SharePoint lists. I would be interested in any kind of a non-commercial solution. Or would the only possiblity be to open the sql table in a client (ms office) app?
You can do it via BCS. Check this out : http://blog.arjanfraaij.com/2011/07/sharepoint-2010-using-bcs-with-sql.html