Forgive me if this is the wrong place to post this question. I looked for a forum on SQL statements but couldn't find one.
I have a FormView with data from two tables in the SqlDataSource. The second table is linked to the first by a FK/PK. There is an example from the Northwind SQL database, e.g. if the Products table is the main table but I want to display the Category Description in the FormView and edit it, how do I write the Update and Insert statements.? I have tried using the query builder in VS 2008 but it doesn't seem to work.
Any help greatly appreciated.
View Complete Post