The following table lists the different templates that you can create.
The LDS has a Where parameter set to point to the Grid View control (i.e.
a Control Parameter): I just don't get how the Form View is clearly bound to a Product object when it is showing its data but looses it when the Update command runs.
) Updated: Your Web.config defines an Ole Db connection string (for the Ole Db engine) that uses the SQL Server Ole Db provider to connect to SQL Server through Ole Db.
Your code then passes that connection string to a Sql Connection, which connects directly to SQL Server using the SQL native client and uses a completely different connection string.
Also if values are different from null, everything works fine.