Sqldatasource onupdating cancel update
Delete Method="Delete Pipeline User" Insert Method="Save Pipeline User" Select Method="Get Pipeline User" Type Name="PTCPipeline.Common" Update Method="Save Pipeline User" On Inserting="obj Common_Inserting" On Updating="obj Common_Updating" This means that the First Name column from your db will be printed in the column.// Iterate through the New Values collection and HTML encode all // user-provided values before updating the data source. New Values) guru_sami, sorry it took me so long to get back, I have been off on vacation and just got back, but yes you are right on, I went back and debugged the entire postback and it was rebinding the grid on postback on the page_load event. I have a grid view that is bound to Sql Data Source. When I’m updating a row I’m getting error: Procedure or function Upsert Site Map has too many arguments specified.
You can go into the Data Source designer to manually change only the UPDATE SQL.USE [Adventure Works] GO /****** Object: Stored Procedure [Human Resources].[Update Employee Gender] Script Date: 04/08/2011 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- ============================================= CREATE PROCEDURE [Human Resources].[Update Employee Gender] @Employee ID [int], @Gender [nchar](1) AS BEGIN UPDATE [Human Resources].[Employee] SET [Gender] = @Gender WHERE [Employee ID] = @Employee ID; END GO Is there any specific reason that column to be identified as User Id in the code?If not, this should resolve your problem right, protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) Is there any specific reason that column to be identified as User Id in the code?However, it also pulls the entered value from the textbox when you are updating and sends it to your Object Data Source's Update Method.Currently, Role ID and Employee ID are the only update parameters showing up during the Updating event because they are the only ones you have specified Bind for instead of Eval.