RadGridView (RowValidating Event)

[Flavio]

Hi,

I am having trouble using the RadGridView (RowValidating Event).

When the RowValidating is fired, the values of my new row to be added are checked,
if one of them is not okay, the message is shown to remind the user to input the correct values.

The problem is:
- if I don´t want to add this new row, how do I discard it?
(in the case I have all cells, for this new row, with null values)

I have the "e. Row. Cancel = true" to try to cancel de adding, and it works,
but the problem is that the phrase "Click here to add a new row" is not set
back to the top, and any other values (Cells) that is in the grid can´t be edited,
it got stuck, until I finish adding this row.

If I erase my "RowValidating" and try again, the problem is solved.

Is it possible to discard a new row
if I have a "RowValidating" on, and once it´s canceled,
to have the phrase "Click here to add a new row" back on top to start over a new adding?

Thanks for your help.

[Stefan]

Hi Flavio,

Thank you for writing.

You can cancel the adding of a new row in the grid by using the following method:

radGridView1.MasterView.TableAddNewRow.CancelAddNewRow();

To make the new row current, set its IsCurrent property:

radGridView1.MasterView.TableAddNewRow.IsCurrent = true;

I hope that you find this information useful.
 
Regards,
Stefan
Telerik

[Vijay]

I am having a similar issue. 
I have RowValidating on my RadGridView and want to be able to handle the ESCAPE KEY as a cancel/abort - so that the would-be added row can be removed and the action can be backed out. 
It is locking up my program due to the expected/forced user input in the row. 

How do I determine if the Escape Key has been pressed at the time of RowValidating, and how do I abort the RowValidating. 
Should I check if the row is empty (is there a best way for this?) and then allow the validating to pass as true so that the escape key works? Would this add a row or continue with the escape key function of cancel? 

Thanks for your time.
Vijay

[Stefan]

Hi Vijay,

Thank you for writing.

To capture the Escape key press you can use the PreviewKeyDown event, where you can raise a flag which will be used in the RowValidating event to prevent the validation cancellation:

bool quitValidating = false;
 void radGridView1_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
 {
     if (e.KeyData == Keys.Escape)
     {
         quitValidating = true;
     }
 }

 void radGridView1_RowValidating(object sender, RowValidatingEventArgs e)
 {
     if (quitValidating == true)
     {
         quitValidating = false;
         return;
     }

     if (e.Row != null && e.Row.Cells[0].Value == null)
     {
         e.Cancel = true;
     }
 }

Please give this approach a try and let me know how it works for you.
 
Regards,
Stefan
Telerik

[Kristoffer]

For me, the "new row" is not updated when I call "CancelAddNewRow()". So, in RowValidating event I have this:

e.Cancel = true;
radGridView1.MasterView.TableAddNewRow.CancelAddNewRow();
radGridView1.MasterView.TableAddNewRow.IsCurrent = true;

Same problem. The new row is blocking user input. I just want to remove it!


UPDATE
Hmm, IsCurrent = false does the trick. Is there a typo?

[Stefan]

Yes there is a typo. You need to make the NewRow not current in order to make it display the "Click here to add new row text".

Please excuse me for the introduced confusion.
 
Regards,
Stefan
Telerik

[Marek Kruk]

Hello, I have the same problem. My grid blocks after:

Private Sub RadGridView1_RowValidating(sender As Object, e As Telerik.WinControls.UI.RowValidatingEventArgs) Handles RadGridView1.RowValidating

    e.Cancel = True
    RadGridView1.MasterView.TableAddNewRow.CancelAddNewRow()
    RadGridView1.MasterView.TableAddNewRow.IsCurrent = False

End Sub

What am I doing wrong?
(UI for WinForms Q3 2013 SP2)

Regards,
Marek

[Stefan]

Hi Marek,

RowValidating is being fired when an attempt to change the current row of the grid is made or when the control looses focus. So, this code will always prevent the current row from being changed and will discard the changes to the new row and will mark it as NOT current, in order to display its text. You need to have some validation logic and to use this code when it fails.

I hope this helps. 

Regards,
Stefan
Telerik

[Jeff]

[quote]Stefan said:Hi Flavio,

Thank you for writing.

You can cancel the adding of a new row in the grid by using the following method:

radGridView1.MasterView.TableAddNewRow.CancelAddNewRow();

To make the new row current, set its IsCurrent property:

radGridView1.MasterView.TableAddNewRow.IsCurrent = true;

I hope that you find this information useful.
 
Regards,
Stefan
Telerik

 

 

[/quote]

Where is this documented?  I can't find anything about this in the validation documentation for GridView.

[Stefan]

Hi Jeff,

Currently, this property is available only in the API documentation here: http://www.telerik.com/help/winforms/m_telerik_wincontrols_ui_gridviewnewrowinfo_canceladdnewrow.html. In future documentation updates, we will consider adding it in the contextual documentation as well. 

I have updated your Telerik Points for this suggestion. 

Regards,
Stefan
Telerik