The ValueChanging event is raised every time a cell's value is being changed. It provides notification that the cell's value is changing and provides the opportunity to cancel any modifications.
Basic steps - C#
To subscribe to the ValueChanging event, the following steps must be performed:
Subscribe to the ValueChanging event of the Cell object using the ValueChangingEventHandler delegate class
Create a new method that will handle the events that are raised.
Place the desired code in the newly created event handler.
Basic steps - VB.NET
To subscribe to the ValueChanging event, the following steps must be performed:
Obtain a reference to a Cell object.
Subscribe to the ValueChanging event of the Cell object using the AddHandler/AddressOf keywords.
Create a new method that will handle the events that are raised.
Place the desired code in the newly created event handler.
Demonstration
This example assumes that you are in a Windows application.
VB.NET
Copy Code
Imports Xceed.Grid
Dim cell As Cell For Each cell in gridControl1.DataRowTemplate.Cells AddHandler cell.ValueChanging, AddressOf Me.cell_ValueChanging Next cell
' This method will handle the ValueChanging events that are raised. Private Sub cell_ValueChanging( ByVal sender As Object, ByVal e As ValueChangingEventArgs ) Try If( e.NewValue is String ) And ( CType( e.NewValue, String ) = "Hello" ) Then e.Cancel = True End If Catch exception As Exception MessageBox.Show( exception.ToString() ) End Try End Sub
' If you no longer wish to handle the ValueChanging events that are raised, ' you can unsubscribe from the event notification by doing the following: RemoveHandler cell.ValueChanging, AddressOf Me.cell_ValueChanging
C#
Copy Code
using Xceed.Grid;
foreach( Cell cell in grid.DataRowTemplate.Cells ) { cell.ValueChanging += new ValueChangingEventHandler( this.cell_ValueChanging ); }
// This method will handle the ValueChanging events that are raised. private void cell_ValueChanging( object sender, ValueChangingEventArgs e ) { try { if( ( e.NewValue is string ) && ( ( string )e.NewValue == "Hello" ) ) { e.Cancel = true; } } catch( Exception exception ) { MessageBox.Show( exception.ToString() ); } }
// If you no longer wish to handle the ValueChanging events that are raised, // you can unsubscribe from the event notification by doing the following: cell.ValueChanging -= new ValueChangingEventHandler( this.cell_ValueChanging );
Copy Code