Click here to Skip to main content
15,889,896 members
Please Sign up or sign in to vote.
4.00/5 (2 votes)
See more:
Hi all

How can I validate a VB.Net DataGridView Cell to accept only Alphabet characters upper and lower. No numbers or special characters are allowed.

Your help please....
Posted

On CellEndEdit Event of DataGridView

Read the Value of Current Cell
i.e.
dataGridView1.CurrentCell.Value.tostring

Check for Your Crieteria.

If crieteria is Not satisfied give message ..
 
Share this answer
 
private void dgvData_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {
            if (e.Exception != null)
            {
                // checking Integer numbers
                if (dgvData.Columns[e.ColumnIndex].ValueType.ToString() == "System.Int32")
                {

                    MessageBox.Show("Enter only Integer values ");
                }
                    // checking decimal values 
                else if (dgvData.Columns[e.ColumnIndex].ValueType.ToString() == "System.Decimal")
                {
                    MessageBox.Show("Enter only numbers");
                }
                else
                {
                    MessageBox.Show("Enter correct format data. Different format data will not accept");
                }
                
            }
        }
 
Share this answer
 
v2


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900