Validation in DataGridView using c#

Question

hello every one well i have data grid view which is bind from data base.. in data grid view's columns accept only integer values not string values... i just want to make function for accepting integer or double values in columns not accepting String values . if have any idea for this function than plz let me know its too urgent . i will appreciate for it.. thnaks in Advance

Nilanka Dharmadasa · Answer

Hi Naim Use datagridview's CellValueChanged event and write following code. private void dataGridView1_CellValueChanged(object sender DataGridViewCellEventArgs e) { double result = 0; if ((dataGridView1.CurrentCell == null) || (dataGridView1.CurrentCell.Value == null)) return; string x = dataGridView1.CurrentCell.Value.ToString(); if (!Double.TryParse(x out result)) { dataGridView1.CurrentCell.Value = null; MessageBox.Show(You have entered a wrong Value!); } }

Naeem Khan · Answer

thnaks nikki u r really good always help full for me thank you so much dear ................

Kirtan Patel · Answer

Do you have Binded DataGridView with Wizard or By Using Code ??? let me know quickly i have your solution !!

Naeem Khan · Answer

sir this is not requirement.. i m asking abut if i change rows values ..like i have in integer values ok so i just put only integer values not character values.. in Data Grid View......... hope u understand what i want...

Naeem Khan · Answer

yes sir it should be in edit mode...

Kirtan Patel · Answer

Friend Here is function I coded to check if Value is Integer or not . if it helps you then check do you like this answer check box :) using System.Text.RegularExpressions; public bool IsInteger( object value) { string x = value.ToString(); Regex rex = new Regex ( [0-9]* ); if (rex.IsMatch(x) == true ) { return true ; } else { return false ; } }