Question

当我用以下代码填写我的数据网格:

Private Sub FormatGridView()
    Dim ILNumColumn As New DataGridViewTextBoxColumn
    Dim ArtNumColumn As New DataGridViewTextBoxColumn
    Dim DescColumn As New DataGridViewTextBoxColumn

     Header text
    ILNumColumn.HeaderText = "# IL"
    ArtNumColumn.HeaderText = "# Articles"
    DescColumn.HeaderText = "Description"

     Wrap
    DescColumn.DefaultCellStyle.WrapMode = DataGridViewTriState.True

     Widths
    ILNumColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells
    ArtNumColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells
    DescColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill

     Add columns
    dgvArticles.Columns.Add(ILNumColumn)
    dgvArticles.Columns.Add(ArtNumColumn)
    dgvArticles.Columns.Add(DescColumn)
End Sub

我想ILNumColumn在其囚室中接受不超过3个号码。

我尝试了以下法典:

ILNumColumn.MaxInputLength = 3

确实没有工作,我仍然可以写“999999”...... 这部法典是否应阻止我打打字,直到我“999”时? 我知道,可以利用各种数据网概貌活动来做到这一点,但我很想知道,在把该栏列入数据网格表之后,能否做到这一点。

谢谢。

Answer 1

Well,我找到了马克斯·InputLength的替代物,因此我使用了CellValidating活动。

Private Sub dgvArticles_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles dgvArticles.CellValidating
     Ensures only numeric values are entered in these fields
    If e.ColumnIndex = 0 Then
        If e.FormattedValue <> "" And (e.FormattedValue < 0 Or e.FormattedValue >= 1000) Then
            MsgBox("IL # must be greater than 0 and less than 1000")
            e.Cancel = True
        End If
    End If
End Sub

Answer 2

为此:

Dim column As DataGridViewTextBoxColumn = DataGridView1.Columns(5) 
column.MaxInputLength = 2

友情链接