Gridview rowupdating get new value
Clicking on the link buttons raise two events: Just like paging events these events follow pre and post pattern.The Sorting event allows you to cancel the operation also.This enables you to provide an event-handling method that performs a custom routine, such as canceling the sorting operation, whenever this event occurs.A Grid View Sort Event Args object is passed to the event-handling method, which enables you to determine the sort expression for the column and to indicate that the selection operation should be canceled.However, when coupled with data source controls the Grid View can toggle the sorting direction automatically for you and you can get/set the direction using this property.The Cancel property allows you to cancel the sorting operation.Further, you need to set Sort Expression property of the Bound Fields to the name of the column on which you would like to sort the grid.
The method essentially binds the Grid View with a Data View.
Other templates used here are Edit Item Template and Footer Template. CREATE PROCEDURE [dbo].[employee_pro] ( @empid as int=0, @name as varchar(50)='', @address as varchar(50)='', @designation as varchar(50)='', @status as varchar(50)='' ) AS BEGIN SET NOCOUNT ON; if(@status = 'Display') begin Select * from employee end else if(@status = 'Add') begin Insert into employee(name,address,designation,createtime) values (@name,@address,@designation,getdate()) end else if(@status = 'Update') begin Update employee set [email protected], [email protected],[email protected] where [email protected] end else if(@status = 'Delete') begin Delete from employee where [email protected] end ENDStored cs using System; using System.
There are many articles and tutorials around that illustrate the use of Grid View control along with the new Data Source Controls.
aspdotnet-suresh offers C#articles and tutorials,csharp dot net,articles and tutorials, VB.
Free counters Added on January 19,2012 Follow Me @vmsdurano A bit About Me Disclaimer The opinions expressed herein are my own personal opinions and does not represent the opinions of my employers.