Update works on some columns

[Christian Saborio]

This is what my site looks like, pretty simple:

http://img.skitch.com/20100418-m8518amduh1bpkeujtixk3ajjb.jpg

I have been using the design editor to create the events for Add, Edit, and Delete.  The Add / Delete work like a charm, but the Edit has issues.  When I am editing a row, if I modify the Enabled and RemoteAccess values, the DB is updated and the values saved.  However, when I type in something into Username and try to update, I get no error, but nothing is updated, not even the Enabled and RemoteAccess values.

My SQL Command is the folllowing:

UpdateCommand="UPDATE [LabUser] SET [Username]=@Username,[Enabled]=@Enabled,[RemoteAccess]=@RemoteAccess WHERE [UserID] = @UserID"

When troubleshooting, I changed @Username to "Foo" and when running the web page it updates correctly, so the issue has to do something with @Username.  This is not read-only and I've included it Username in the DataKeyNames.

Any idea what can be causing this behavior?  Thanks!

[Veli]

Hello Christian,

Hook up to RadGrid's ItemUpdated event and see if there is an exception thrown when attempting to update:

protected void RadGrid1_ItemUpdated(object source, GridUpdatedEventArgs e)
{
    if (e.Exception != null)
    {
        //if code goes here, there has been an exception on update
        //e.Exception.Message or e.Exception.InnerException.Message
        //give you the exception messaged
    }
}

Best wishes,
Veli
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.