Because this is too simple, I wonder I might just did something dummy, and the fix should be easy. I see that you faced the bug that was fixed in v2010 vol 2.8.
As you know, upgrading version is not easy, we have to serious plan ahead. Please read the ASPx Grid View - It is impossible to get editors values of the Edit Form in the Html Edit Form Created event handler report where we describe how to overcome it.
We will examine it on our side under the same conditions. You should see the new inserting record has all values NULL. I should say that the application works fine, and I do not get the exception during the insert action. I created a Categories table tp test the sample project you sent. Please note: the problem is not "null reference exception". Yang Yang, Version v2010 vol 2.8 contains some critical fixes related to templates.
I also had a problem when updating: I received "Primary Key does not exist...". There is no exception, the insert can go through, but every value is NULL. These fixes cannot be applied to v2010 vol 2.5, and thus you have to upgrade your application.
WHERE Convert(varchar(100), Addr GUID) = @String GUID and the Sql Data Source Update Command must use: UPDATE table SET .....
WHERE Convert(varchar(100), Addr GUID) = @String GUID -- Thank you kindly, Dan Sikorsky BA, BSCE, MCS "Dan Sikorsky" wrote: Environment: VS2005, C#, SQLServer 2005 Error Message: Object Must Implement IConvertible I'm using a Form View whose Data Source ID = Sql Data Source1 Sql Data Source1 has an update command whose WHERE clause references an GUID column in the underlying table,ie, WHERE Addr GUID = @Addr GUID Addr GUID is the primary key on the table and the Form View Data Key Names=Addr GUID.All Sql Data Source parameters are to be typed as Strings.The Sql Data Source Select Command must use: SELECT Convert(varchar(100), Addr GUID) As Addr GUID, ...The following code example demonstrates how to display data that is retrieved from a Microsoft SQL Server database in a Drop Down List control and update the record using a Text Box control.The example shows how you can use a Db Transaction object to add transaction context when using the Sql Data Source control to update data.-- Thank you kindly, Dan Sikorsky BA, BSCE, MCS Just solved it.The Grid View, Form View must use strings for the GUIDs, so the Sql Data Source must convert the guids to strings.No Sql Data Source_On Updating event occurs, which I believe it should.How can I use update statements in a Sql Data Source whose table has a uniqueidentifier/GUID as a primary key?The Details View changes to Edit Mode, but after clicking on the Update Button it shows the old data.Am I missing something or is it just not possible or perhaps a beta problem?