How to link update table with data grid view without command builder

Question

Im trying to use a datagridview to view and edit the tables data, i was using a command builder but i cannot update to multiple tables using it (because im using a view). The error i was recieving was - "Dynamic SQL generation is not supported against multiple base tables.". Was wondering if anyone could explain to me how to approach this thanks