The following code successfully displays a record in a FormView and sets the FormView mode to 'Edit' when the user clicks on a LinkButton within a Repeater, however the record is not Updated. If I don't change the .SelectCommand and call .DataBind, I'm able to update the first record that is displayed. Naturally that's a moot point because the idea is to be able to update the record that the user selects in the Repeater. Because of the design of the FormView and Repeater, the record *must* be updated via the FormView. Updating the record via the Repeater is not an option.
Protected Sub RepeaterMessages_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs)
SqlDataSourceMessageDetail.SelectCommand = "SELECT [Id], [MessageDateTime], [MessageOwner], [Subject], [Body], [AllowReplies], [ExpirationDateTime], [IsCityWideMessage], [DepartmentId], [BranchId], [CompanyFacilityId], [ShowNumber], [IsHighPriority], [UpdateDateTime] FROM [Messages] WHERE ID = " & e.CommandArgument
View Complete Post