编辑GridView时只能输入数字.doc

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace WindowsFormsApplication4 public partial class Form2 : Form public Form2() InitializeComponent(); private void Form2_Load(object sender, EventArgs e) / TODO: 这行代码将数据加载到表“testDataSet3.salary”中。您可以根据需要移动或移除它。 this.salaryTableAdapter.Fill(this.testDataSet3.salary); / TODO: 这行代码将数据加载到表“testDataSet1.login”中。您可以根据需要移动或移除它。 this.loginTableAdapter.Fill(this.testDataSet1.login); dataGridView1.Columns0.ReadOnly = true; dataGridView1.Columns4.ReadOnly = true; private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) dataGridView1.Columns0.ReadOnly = false; int s1 = Convert.ToInt32(dataGridView1.CurrentRow.Cells1.Value); int s2 = Convert.ToInt32(dataGridView1.CurrentRow.Cells2.Value); int s3 = Convert.ToInt32(dataGridView1.CurrentRow.Cells3.Value); dataGridView1.CurrentRow.Cells4.Value = s1 + s2 + s3; int s4=s1 + s2 + s3; SqlConnection conn = new SqlConnection(Server=(local);Integrated Security=True; + Database=Test); conn.Open(); SqlCommand comm = new SqlCommand(update salary set 基本工资 = + s1 + ,奖励= + s2 + ,全勤=+s3+,应发工资=+s4+where 员工姓名= + dataGridView1.CurrentRow.Cells0.ToString() + , conn); comm.ExecuteNonQuery(); /MessageBox.Show(修改成功！); private void dataGridView1_KeyPress(object sender, KeyPressEventArgs e) /if (!char.IsDigit(e.KeyChar) / / MessageBox.Show(sdfsdf); / e.Handled = true; / private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) if (e.ColumnIndex = 1 | e.ColumnIndex = 2 |e.ColumnIndex=3|e.ColumnIndex=4) try if (String.IsNullOrEmpty(e.FormattedValue.ToString() else decimal val = decimal.Parse(e.FormattedValue.ToString(); catch (Exception