編輯GridView時只能輸入數(shù)字

1、-作者xxxx-日期xxxx編輯GridView時只能輸入數(shù)字【精品文檔】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 For

2、m2 : Form public Form2() InitializeComponent(); private void Form2_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“”中。您可以根據(jù)需要移動或移除它。 this.salaryTableAdapter.Fill(this.testDataSet3.salary); / TODO: 這行代碼將數(shù)據(jù)加載到表“”中。您可以根據(jù)需要移動或移除它。 this.loginTableAdapter.Fill(this.testDataSet1.login); dataGridView1.

3、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.Curren

4、tRow.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(); SqlCo

5、mmand comm = new SqlCommand("update salary set 基本工資 ='" + s1 + "',獎勵='" + s2 + "',全勤='"+s3+"',應(yīng)發(fā)工資='"+s4+"'where 員工姓名='" + dataGridView1.CurrentRow.Cells0.ToString() + "' ", conn); comm.ExecuteNonQuer

6、y(); /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 ex) dataGridView1.