问题描述
大家好，
我创建了一个Windows窗体应用程序，其中有一个gridview和一个名为保存数据"的按钮.
我在gridview中有三列分别名为formno，学生姓名和地址，..
从网格视图，我想在创建到数据库的表中插入多行.直到这里我完成.
现在，我的问题是验证ach列，如表格No.所示.列用户只能输入数值，而在学生姓名列上，用户可以输入字母.我不知道我会怎么...
请帮助我！
hello everyone,
i have created a windows forms application where i have a gridview and a button named Save Data.
i have three column in gridview named formno, student name and address respectively,..
from the grid view i want to insert multiple rows into the table created into the database. TILL HERE I DONE THIS.
now, my problem is to validate ach column like in form no. column user can enter only numeric value and on the student name column, user can enter on aplhabetical character. i don''t know how would i....
please help me!
推荐答案
if (gv.currentcell.columnindex==0) //name for alphabets only
{
if (!(Char.IsLetter(e.KeyChar) == true ||(e.KeyChar)==8))
{
e.cancel = true;
}
}
else if (<pre lang="cs">gv.currentcell.columnindex==1)//for numeric values only
{
if (!(Char.IsDegit(e.KeyChar) == true ||(e.KeyChar)==8))
{
e.cancel = true;
}
}
.
.
.
祝您编码愉快！
:)
Happy Coding!
:)
Private Sub datagridview1_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles dgv_view.EditingControlShowing
'---restrict inputs
Dim tb As TextBox
tb = CType(e.Control, TextBox)
If DataGridView1.CurrentCell.ColumnIndex = 1 Then
tb.AutoCompleteCustomSource = scAutoComplete
End If
End Sub
' then take textbox keypress event
Private Sub TextBox_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs)
e.KeyChar = Allowchars(e.KeyChar)
End Sub
'then take textbox keypress event
Private Sub TextBox_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs)
e.KeyChar = Allowchars(e.KeyChar)
End Sub
这篇关于在数据网格视图上编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！