Validate Cell DataGrid

[Gilberth]

Hello again, this is my doubt, I wish to validate a cell in GridView, this cell type is gridviewtextboxcolumn, this desire can only enter numeric values, ie, to type a letter or symbol I can not accept, do not put gridviewdecimalcolumn one because in this test can type a zero, eg 0101 and the gridviewdecimalcolumn not recognize me the first 0, I have not updated to the new version have taken Q2 because I found some bugs in this version, I'm just waiting for an answer to other post to see if it entered graduate or not, I have found this review validacion can be done with the event but editcontrolshowing datagrid visual studio that brings hope prompt response and thank you in advance for the help I provide.

Note: giving hope to understand, my English is not very good, thanks again.

[Gilberth]

    Searching I found as a solution using GridViewMaskBoxColumn, which allows me to enter numbers only, however if they have a better way, I thank you for the help, thanks

[Jack]

Hello Gilberth,

I am glad to hear that you have found solution for this issue. Maybe this is the best option when using Q1 2009. I still recommend you try our latest release Q2 2009. It addresses many issues and contains several new features.

You can review our help article about data validation. If you have any other questions, don't hesitate to ask.

Kind regards,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Gilberth]

Hello again, please see this ticket, these are the errors I found in the new Q2, therefore unwanted upgrade, I expect any positive response on these mistakes to follow your advice, thank you for answering.

http://www.telerik.com/account/support-tickets/view-ticket.aspx?threadid=225707

[Jack]

Hello Gilberth,

Please find the answer in the support ticket.

Kind regards,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Gilberth]

Hello, I wanted to respond on the same ticket, but did not find how to do it, if I understood well the error referred to is found in the latest version of the Q2 control MultiColumnComboBox This error occurs when you select an item from the list that contains , also to write some of the items, ie when the control is going to filter, this sends the same error, I put the code for the filter I found in the forum or that you gave me or that the Help do not remember where I got it right, even when pressing the button up or down key, I guess it should select an item from the list, but sends me the same error as comment is as follows:

Comboentradas.AutoFilter = True
Dim filter_entrada As New FilterExpression(Comboentradas.DisplayMember, FilterExpression.BinaryOperation.AND, GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName)
filter_entrada.Parameters.Add(GridFilterCellElement.ParameterName, String.Empty)
Comboentradas.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filter_entrada)
Comboentradas.MultiColumnComboBoxElement.AutoCompleteMode = AutoCompleteMode.Suggest

I hope to have given enterder error, Thanks for responding, hope I have helped somewhat in the evolution of these great controls and thanks for all the help I provide.

Edit:    One thing I like about the new version validacion Q2 is the GridView control, you can somehow do the same in the GridView control version of the Q1, the validacion to which I refer is when, for example, if the value is lower one above, the GridView puts an icon on the left side of the row, and the cell painted red, is something that I like and trying to make but could not find a way to do it, you can do in the old version Q1 ?, thanks again for everything.

[Vassil Petev]

Hello Gilberth,

The validation feature is available since Q2 2009 - it is not possible out-of-the-box in Q1.

You are not able to reply in the ticket, because your trial support has expired. In case you have obtained copy of our controls through the company you work for, please ask the purchase holder in the company to add you as a License Developer to this purchase - this will unlock the support ticketing system. More on license Developers you can find here: http://www.telerik.com/account/faqs.aspx


Kind regards,
Vassil
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Rawad]

Dear Vassil Petev

How to prevent user to enter alphanumeric in some rows using GridViewTextBoxColum.
Lets say I have a grid with 2 columns GridViewTextBoxColum, I need for the second column for some rows (not all) that user just enter a numeric, or integer value,  for example

Column1          Column2
Name                (user here  can enter a string)
Age                    (user here can just enter a numeric)

Could you please give an example using VB.net .

Thanks

[Stefan]

Hello Rawad,

Thank you for writing.

To do that you can use the CellValidating event and prevent the user from leaving the cell unless valid value is entered:

Private Sub radGridView1_CellValidating(sender As Object, e As CellValidatingEventArgs)
    Dim n As Integer
    Dim isNumeric As Boolean = Integer.TryParse(e.Value.ToString(), n)

    If e.Column.Name = "Column2" AndAlso e.Row.Cells("Column1").Value = "Age" AndAlso isNumeric = False Then
        'we will prevent the user from leaving the cell unless s/he entered numeric value for this cell
        e.Cancel = True
    End If
End Sub

More information about data validation is available here: http://www.telerik.com/help/winforms/gridview-editors-data-validation.html.

I hope this helps.

Regards,
Stefan
Telerik

 

 

[Rawad]

hello stefan

nice solution, but why to let user enter alphanumeric while i just need integer,  it's better to not allow him from the beginning.
I tried the following code and it worked with me, but just first time and for the first letter, it allows alphanumeric.

    Private Sub radGridView1_CellBeginEdit(sender As Object, e As GridViewCellCancelEventArgs) Handles RadGridView1.CellBeginEdit
        Dim editor As RadTextBoxEditor = DirectCast(e.ActiveEditor, RadTextBoxEditor)
        If Not IsNothing(editor) Then
            Dim editorElement As RadTextBoxEditorElement = DirectCast(editor.EditorElement, RadTextBoxEditorElement)
            AddHandler editorElement.KeyPress, AddressOf KeyPresses
        End If
    End Sub

    Private Sub KeyPresses(sender As Object, e As KeyPressEventArgs)
        If Asc(e.KeyChar) <> 8 Then
            If ((Asc(e.KeyChar) < 48 Or Asc(e.KeyChar) > 57) And Asc(e.KeyChar) <> 46) Then
                e.Handled = True
            End If
        End If
    End Sub

Any idea ?

[Stefan]

Hello Rawad,

Here is how your code might look like:

Private Sub radGridView1_CellBeginEdit(sender As Object, e As GridViewCellCancelEventArgs)
    Dim editor As RadTextBoxEditor = DirectCast(e.ActiveEditor, RadTextBoxEditor)
    If (editor IsNot Nothing) Then
        Dim editorElement As RadTextBoxEditorElement = DirectCast(editor.EditorElement, RadTextBoxEditorElement)
        RemoveHandler editorElement.KeyPress, AddressOf KeyPresses
        AddHandler editorElement.KeyPress, AddressOf KeyPresses
    End If
End Sub

Private Sub KeyPresses(sender As Object, e As KeyPressEventArgs)
    If Not Char.IsNumber(e.KeyChar) Then
        e.Handled = True
    End If
End Sub

It is important that you remove the handler prior adding it, as editor are being reused in the grid and this way you will avoid multiple subscriptions.

I hope that the provided information addresses your question.

Regards,
Stefan
Telerik