DataGridView只能输入数字型

 public partial class Form2 : Form
    {
        private DataGridViewTextBoxEditingControl EditingControl;

       
        private void EditingControl_KeyPress(object sender, KeyPressEventArgs e)
        {
            if(e.KeyChar.ToString()=="\b"||e.KeyChar.ToString()==".")
            {
                e.Handled = false; return;
            }
            if (!char.IsDigit(e.KeyChar)) e.Handled = true;
          
        }

        public Form2()
        {
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            ds = GetExcelContent();
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
        }

        private DataSet GetExcelContent()
        {
            string G_Str_ConnectionString = "SERVER=(local);DATABASE=db_GoodsManage;UID=sa;PWD=111111";
            SqlConnection myConn = new SqlConnection(G_Str_ConnectionString);
            string strCom = "SELECT * FROM v_UserView";
            myConn.Open();
            SqlDataAdapter myCommand = new SqlDataAdapter(strCom, myConn);
            //创建一个DataSet对象  
            DataSet myDataSet = new DataSet();
            //得到自己的DataSet对象  
            myCommand.Fill(myDataSet);
            //关闭此数据链接  
            myConn.Close();
            return myDataSet;
        }

        private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
            EditingControl.KeyPress += new KeyPressEventHandler(EditingControl_KeyPress);
        }
    }

posted on 2009-04-10 14:08  heart-in-sky  阅读(674)  评论(0编辑  收藏  举报