First of all I have to say that my skill level in C# is rather basic so please bear with me. I will use AdventureWorks2012 as the example here. I create a SQL view using the statement (Select e.BusinessEntityID, p.Firstname, p.Lastname FROM HumanResources.employee e JOIN person.person p). Now I create a tableadapter in my C# project and use SQL statement to call the view, put it on a gridView and have the user edit say the firstname field. How do I save it back to the sql view? The updateCommand does not generate.