How to validate DataGridViewTextBoxColumn ?

Question

Hi all..

I am new to Windows Application Development.

I have a grid view of type Data Grid View Text Box Column. In that grid I have two columns Qty & Rate which should accept number only.

How to validate these two columns..??

Please help,

Thanks in advance.

Animesh Datta · Answer

You can use dataGridView_CellEndEdit Event to validate the columns . private void dataGridView_CellEndEdit(object sender DataGridViewCellEventArgs e) { DataGridViewRow dgvrow = dataGridViewEmployeeLeaf.Rows[e.RowIndex]; //Get the current row index if (dgvrow.Cells[index].Value != null && dgvrow.Cells[index].Value.ToString().Trim() != ) { dgvrow.Cells[index].Value = checkint(dgvrow.Cells[index].Value.ToString()); } } //Function of Checking Integer number public int checkint(string tb) { int a = 0; if (tb != ) { try { a = int.Parse(tb); } catch { MessageBox.Show(Invalid Number Data Entry Error MessageBoxButtons.OK MessageBoxIcon.Information); tb = ; } } return a; }

Riyaz Kalva · Answer

Thanks for answer @Animesh Datta It works fine but I want to allow the user to press the backspace key for wrong entry. Please help me how to accomplish this?