DataGridView列值值输入非法就屏蔽，例如数字列不允许输入中文

 

1、先定义键盘事件

   public DataGridViewTextBoxEditingControl CellEdit = null; // 声明 一个 CellEdit 输入法控制


1  private void dataGridView2_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            CellEdit = (DataGridViewTextBoxEditingControl)e.Control; // 赋值
            CellEdit.SelectAll();
            CellEdit.KeyPress += Cells_KeyPress; // 绑定到事件 
        }

2、输入非法就屏蔽

/// <summary>
        /// 单元格输入键事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Cells_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (dataGridView2.CurrentCellAddress.X == 11 || dataGridView2.CurrentCellAddress.X == 12 || dataGridView2.CurrentCellAddress.X == 13) // 判断当前列是不是要控制的列 我是控制的索引值为2的  列(即第三列)
            {
                if ((Convert.ToInt32(e.KeyChar) < 48 || Convert.ToInt32(e.KeyChar) > 57) && Convert.ToInt32(e.KeyChar) != 46 && Convert.ToInt32(e.KeyChar) != 8 && Convert.ToInt32(e.KeyChar) != 13)
                {
                    e.Handled = true;  // 输入非法就屏蔽
                }
                else
                {
                    if ((Convert.ToInt32(e.KeyChar) == 46))
                    {
                        e.Handled = true;
                    }
                }
            }
        }

 3、某数字列的值校验

private void dataGridView2_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
        {
            if (e.ColumnIndex == dataGridView2.Columns["price"].Index || e.ColumnIndex == dataGridView2.Columns["amount"].Index)
            {
                dataGridView2.Rows[e.RowIndex].ErrorText = "";
                decimal NewVal = 0;
                if (!decimal.TryParse(e.FormattedValue.ToString(), out NewVal) || NewVal < 0)
                {
                    e.Cancel = true;
                    dataGridView2.Rows[e.RowIndex].ErrorText = "价格、金额列只能输入数字";
                    return;
                }
            }
            else if (e.ColumnIndex == dataGridView2.Columns["qty"].Index)
            {
                dataGridView2.Rows[e.RowIndex].ErrorText = "";
                decimal NewVal = 0;
                if (!decimal.TryParse(e.FormattedValue.ToString(), out NewVal) || NewVal < 0)
                {
                    e.Cancel = true;
                    dataGridView2.Rows[e.RowIndex].ErrorText = "数量列只能输入整型数字";
                    return;
                }
            }
        }