This is a migrated thread and some comments may be shown as answers.

Anyway to force row/cell validation

11 Answers 1609 Views

GridView

This is a migrated thread and some comments may be shown as answers.

11 Answers, 1 is accepted

answered on 26 Jan 2012, 09:49 AM

Hi Svein Thomas,

Thank you for contacting us. Directly to your questions:

1. CellValidating and RowValidating events fire when the current cell/row is being changed or when ending an edit operation. You can force these events to fire by setting the CurrentRow/CurrentColumn properties to different value or by calling the EndEdit method to finish the current edit operation.

2. No values are changed in the data source before validation. However, I am not sure that I fully understand your scenario. Please, could you elaborate a bit more and describe in detail what you want to achieve. I will be glad to assist further.

I am looking forward to your reply.

Regards,
Jack
the Telerik team

SP1 of Q3’11 of RadControls for WinForms is available for download (see what's new).

answered on 21 Jun 2012, 01:30 AM

I think I am looking for the same effect.

I have a grid with values in it; quantity, price, discount (%), unit price.

If the user wished to place a discount on each row, they enter it once, and then in a For Each loop, I place the value in the cell; however the calculation does not take place. it appears as if the CellValidating or RowValidating events are not firing.

Here is my snipit of code:

For Each r As GridViewDataRowInfo In InvoiceDetailsGridView.Rows

r.Cells("colDiscount").Value = DiscountTextBox.Value

Next

InvoiceDetailsGridView.Refresh()

The user can manually enter a value in the discount field, and the calculation takes place.

Any ideas?

Thanks
Bob

answered on 28 Jun 2012, 07:39 AM

Hi Bob,

Yes, your assumption is correct. In this case the CellValidating event will not fire. I am not sure whether it helps, however you can force this event to fire by using the EventDispatcher class. Here is a sample:

GridViewRowInfo row = this.radGridView1.Rows[1];

GridViewColumn column = this.radGridView1.Columns["Value"];

object oldValue = row.Cells["Value"].Value;

object newValue = 10;

CellValidatingEventArgs cellValidating = new CellValidatingEventArgs(row, column, newValue, oldValue, null);

this.radGridView1.MasterTemplate.EventDispatcher.RaiseEvent<CellValidatingEventArgs>(EventDispatcher.CellValidating,

this.radGridView1, cellValidating);

if (!cellValidating.Cancel)

{

row.Cells["Value"].Value = newValue;

}

If you need further assistance, I will be glad to help.

All the best,
Jack
the Telerik team

RadControls for WinForms Q2'12 release is now live! Check out what's new or download a free trial >>

answered on 16 Mar 2020, 12:58 AM

Just wanted to say thanks for the code snippet of how to trigger the validate event.

In my case, I was loading data that possibly contained errors ( when opening data into an editing form).The user must update these..
I wanted a way to have cell validation for when the user tried changing values.. but also needed to handle the user hits 'Save' without even giving the grid focus. ( so no validate events are fired)

So I just made this generic sub to fire off a validate event for every cell and then check the whole grid had no errors. I am loading a small amount of data, so works well.

Private Function IsValid(Grid As RadGridView) As Boolean

For r = 0 To Grid.Rows.Count -1

For c As Integer = 0 to Grid.Columns.Count -1

Dim row As GridViewRowInfo = Grid.Rows(r)

Dim column As GridViewColumn = Grid.Columns(c)

If column.IsVisible Then

Dim Value As Object = Grid.Rows(0).Cells(c).value

Dim cellValidating As CellValidatingEventArgs = New CellValidatingEventArgs(row, column, Value, Value, Nothing)

Grid.MasterTemplate.EventDispatcher.RaiseEvent(Of CellValidatingEventArgs)(EventDispatcher.CellValidating,Grid, cellValidating)

End if

Next

'Now to look through the row's checking for any errors (Validate event handle adds to the row Errortext)

For re = 0 To Grid.Rows.Count -1

if NOT String.IsNullOrWhiteSpace(CustomerGrid.Rows(re).ErrorText) Then Return false

next

return true

End Function

Maybe helps someone

Rob

answered on 16 Mar 2020, 01:26 PM

Hello, Rob,

Thank you for sharing your code with the community.

I have updated your Telerik points for community effort.

Note that you can also iterate the cells for all rows in RadGridView and simply check the value. It is not actually necessary to fire the CellValidating event in order to properly validate the cells.

However, feel free to use this approach which suits your requirements best.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Anyway to force row/cell validation

11 Answers, 1 is accepted