Hi everybody,
I'm having a problem to get the GGC to work with LinqToSQL.
OK this is my starting point: I take the Northwind "Products" table, set up a LINQtoSQL datacontext, build a LINQ-Query with the products table and bind it to the datasource of a bindingsource. This bindingsource is then attached to the GGC.
So far the program works as expected: the grid shows all the data, grouping works like a charm.
But now the problem: when I change the value of the CategoryID to assign another category for the product and then leave the row I get a SaveRecord error. After some debugging I found the reason for the error: the datacontext claims that the product already has a foreign key value and that it can't assign a new value.
But now the fun part of the whole: if I only replace the GGC with a standard GDBG (GridDataBoundGrid) the above works without an error message.
Can someone tell me the reason why these to controls behave so differently? How can I get the GGC working without an error?
Yours Detlef