DataGridView.CellValueChanged 事件

定義

命名空間:

System.Windows.Forms

組件:

System.Windows.Forms.dll

儲存格的值變更時發生。

public:
 event System::Windows::Forms::DataGridViewCellEventHandler ^ CellValueChanged;

public event System.Windows.Forms.DataGridViewCellEventHandler CellValueChanged;

member this.CellValueChanged : System.Windows.Forms.DataGridViewCellEventHandler 

Public Custom Event CellValueChanged As DataGridViewCellEventHandler 

事件類型

DataGridViewCellEventHandler

範例

下列程式碼範例示範如何使用 CellValueChanged 事件來更新 餘額資料行 DataGridView 中的值。 此範例是事件中可用的較大範例的 SelectionChanged 一部分。

private void DataGridView1_CellValueChanged(
    object sender, DataGridViewCellEventArgs e)
{
    // Update the balance column whenever the value of any cell changes.
    UpdateBalance();
}

private void DataGridView1_RowsRemoved(
    object sender, DataGridViewRowsRemovedEventArgs e)
{
    // Update the balance column whenever rows are deleted.
    UpdateBalance();
}

private void UpdateBalance()
{
    int counter;
    int balance;
    int deposit;
    int withdrawal;

    // Iterate through the rows, skipping the Starting Balance row.
    for (counter = 1; counter < (DataGridView1.Rows.Count - 1);
        counter++)
    {
        deposit = 0;
        withdrawal = 0;
        balance = int.Parse(DataGridView1.Rows[counter - 1]
            .Cells["Balance"].Value.ToString());

        if (DataGridView1.Rows[counter].Cells["Deposits"].Value != null)
        {
            // Verify that the cell value is not an empty string.
            if (DataGridView1.Rows[counter]
                .Cells["Deposits"].Value.ToString().Length != 0)
            {
                deposit = int.Parse(DataGridView1.Rows[counter]
                    .Cells["Deposits"].Value.ToString());
            }
        }

        if (DataGridView1.Rows[counter].Cells["Withdrawals"].Value != null)
        {
            if (DataGridView1.Rows[counter]
                .Cells["Withdrawals"].Value.ToString().Length != 0)
            {
                withdrawal = int.Parse(DataGridView1.Rows[counter]
                    .Cells["Withdrawals"].Value.ToString());
            }
        }
        DataGridView1.Rows[counter].Cells["Balance"].Value =
            (balance + deposit + withdrawal).ToString();
    }
}

Private Sub CellValueChanged(ByVal sender As Object, _
    ByVal e As DataGridViewCellEventArgs) _
    Handles DataGridView1.CellValueChanged

    ' Update the balance column whenever the values of any cell changes.
    UpdateBalance()
End Sub

Private Sub RowsRemoved(ByVal sender As Object, _
    ByVal e As DataGridViewRowsRemovedEventArgs) _
    Handles DataGridView1.RowsRemoved

    ' Update the balance column whenever rows are deleted.
    UpdateBalance()
End Sub

Private Sub UpdateBalance()
    Dim counter As Integer
    Dim balance As Integer
    Dim deposit As Integer
    Dim withdrawal As Integer

    ' Iterate through the rows, skipping the Starting Balance Row.
    For counter = 1 To (DataGridView1.Rows.Count - 2)
        deposit = 0
        withdrawal = 0
        balance = Integer.Parse(DataGridView1.Rows(counter - 1) _
            .Cells("Balance").Value.ToString())

        If Not DataGridView1.Rows(counter) _
            .Cells("Deposits").Value Is Nothing Then

            ' Verify that the cell value is not an empty string.
            If Not DataGridView1.Rows(counter) _
                .Cells("Deposits").Value.ToString().Length = 0 Then
                deposit = Integer.Parse(DataGridView1.Rows(counter) _
                    .Cells("Deposits").Value.ToString())
            End If
        End If

        If Not DataGridView1.Rows(counter) _
            .Cells("Withdrawals").Value Is Nothing Then
            If Not DataGridView1.Rows(counter) _
                .Cells("Withdrawals").Value.ToString().Length = 0 Then
                withdrawal = Integer.Parse(DataGridView1.Rows(counter) _
                    .Cells("Withdrawals").Value.ToString())
            End If
        End If

        DataGridView1.Rows(counter).Cells("Balance").Value = _
            (balance + deposit + withdrawal).ToString()
    Next
End Sub

備註

認可 DataGridView.CellValueChanged 使用者指定的值時，通常會在焦點離開儲存格時發生此事件。

不過，在核取方塊儲存格的情況下，您通常會想要立即處理變更。 若要在按一下儲存格時認可變更，您必須處理 DataGridView.CurrentCellDirtyStateChanged 事件。 在處理常式中，如果目前的儲存格是核取方塊儲存格，請呼叫 DataGridView.CommitEdit 方法並傳入 Commit 值。

控制項中的資料列不會在儲存格值變更時自動排序。 若要在使用者修改儲存格時排序控制項，請在事件處理常式中 CellValueChanged 呼叫 Sort 方法。

如需如何處理事件的詳細資訊，請參閱 處理和引發事件。

另請參閱

• DataGridView 控制項 (Windows Form)