DataGridViewCell.FormattedValue 屬性

參考

定義

命名空間:: System.Windows.Forms

組件:: System.Windows.Forms.dll

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

取得儲存格的格式化值，以供顯示。

public:
 property System::Object ^ FormattedValue { System::Object ^ get(); };

[System.ComponentModel.Browsable(false)]
public object FormattedValue { get; }

[System.ComponentModel.Browsable(false)]
public object? FormattedValue { get; }

[<System.ComponentModel.Browsable(false)>]
member this.FormattedValue : obj

Public ReadOnly Property FormattedValue As Object

屬性值

Object

如果儲存格不屬於 DataGridView 控制項，則為儲存格的已格式化值或 null。

屬性: BrowsableAttribute

例外狀況

InvalidOperationException

ColumnIndex 小於 0，表示儲存格是資料列行首儲存格。

ArgumentOutOfRangeException

包含儲存格的資料列是共用的資料列。

-或-

儲存格是資料行行首儲存格。

Exception

格式化失敗，而且 DataError 控制項的 DataGridView 事件沒有處理常式，或是該處理常式將 ThrowException 屬性設定為 true。例外狀況物件通常可轉換成 FormatException 類型。

範例

下列程式碼範例示範如何使用 FormattedValue 屬性。在此範例中 IsCurrentCellDirty ，屬性是用來判斷目前儲存格的內容是否已編輯且未認可，而且如果已修改儲存格， FormattedValue 則會使用。此範例是事件中可用的較大範例的 DataGridView.SelectionChanged 一部分。

private void UpdateLabelText()
{
    int WithdrawalTotal = 0;
    int DepositTotal = 0;
    int SelectedCellTotal = 0;
    int counter;

    // Iterate through all the rows and sum up the appropriate columns.
    for (counter = 0; counter < (DataGridView1.Rows.Count);
        counter++)
    {
        if (DataGridView1.Rows[counter].Cells["Withdrawals"].Value
            != null)
        {
            if (DataGridView1.Rows[counter].
                Cells["Withdrawals"].Value.ToString().Length != 0)
            {
                WithdrawalTotal += int.Parse(DataGridView1.Rows[counter].
                    Cells["Withdrawals"].Value.ToString());
            }
        }

        if (DataGridView1.Rows[counter].Cells["Deposits"].Value != null)
        {
            if (DataGridView1.Rows[counter]
                .Cells["Deposits"].Value.ToString().Length != 0)
            {
                DepositTotal += int.Parse(DataGridView1.Rows[counter]
                    .Cells["Deposits"].Value.ToString());
            }
        }
    }

    // Iterate through the SelectedCells collection and sum up the values.
    for (counter = 0;
        counter < (DataGridView1.SelectedCells.Count); counter++)
    {
        if (DataGridView1.SelectedCells[counter].FormattedValueType ==
            Type.GetType("System.String"))
        {
            string value = null;

            // If the cell contains a value that has not been commited,
            // use the modified value.
            if (DataGridView1.IsCurrentCellDirty == true)
            {

                value = DataGridView1.SelectedCells[counter]
                    .EditedFormattedValue.ToString();
            }
            else
            {
                value = DataGridView1.SelectedCells[counter]
                    .FormattedValue.ToString();
            }
            if (value != null)
            {
                // Ignore cells in the Description column.
                if (DataGridView1.SelectedCells[counter].ColumnIndex !=
                    DataGridView1.Columns["Description"].Index)
                {
                    if (value.Length != 0)
                    {
                        SelectedCellTotal += int.Parse(value);
                    }
                }
            }
        }
    }

    // Set the labels to reflect the current state of the DataGridView.
    Label1.Text = "Withdrawals Total: " + WithdrawalTotal.ToString();
    Label2.Text = "Deposits Total: " + DepositTotal.ToString();
    Label3.Text = "Selected Cells Total: " + SelectedCellTotal.ToString();
    Label4.Text = "Total entries: " + DataGridView1.RowCount.ToString();
}

Private Sub UpdateLabelText()
    Dim WithdrawalTotal As Integer = 0
    Dim DepositTotal As Integer = 0
    Dim SelectedCellTotal As Integer = 0
    Dim counter As Integer

    ' Iterate through all the rows and sum up the appropriate columns.
    For counter = 0 To (DataGridView1.Rows.Count - 1)
        If Not DataGridView1.Rows(counter) _
            .Cells("Withdrawals").Value Is Nothing Then

            If Not DataGridView1.Rows(counter) _
                .Cells("Withdrawals").Value.ToString().Length = 0 Then

                WithdrawalTotal += _
                    Integer.Parse(DataGridView1.Rows(counter) _
                    .Cells("Withdrawals").Value.ToString())
            End If
        End If

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

            If Not DataGridView1.Rows(counter) _
                .Cells("Deposits").Value.ToString().Length = 0 Then

                DepositTotal += _
                    Integer.Parse(DataGridView1.Rows(counter) _
                    .Cells("Deposits").Value.ToString())
            End If
        End If
    Next

    ' Iterate through the SelectedCells collection and sum up the values.
    For counter = 0 To (DataGridView1.SelectedCells.Count - 1)
        If DataGridView1.SelectedCells(counter).FormattedValueType Is _
        Type.GetType("System.String") Then

            Dim value As String = Nothing

            ' If the cell contains a value that has not been commited,
            ' use the modified value.
            If (DataGridView1.IsCurrentCellDirty = True) Then

                value = DataGridView1.SelectedCells(counter) _
                    .EditedFormattedValue.ToString()
            Else

                value = DataGridView1.SelectedCells(counter) _
                    .FormattedValue.ToString()
            End If

            If value IsNot Nothing Then

                ' Ignore cells in the Description column.
                If Not DataGridView1.SelectedCells(counter).ColumnIndex = _
                    DataGridView1.Columns("Description").Index Then

                    If Not value.Length = 0 Then
                        SelectedCellTotal += Integer.Parse(value)
                    End If
                End If
            End If
        End If

    Next

    ' Set the labels to reflect the current state of the DataGridView.
    Label1.Text = "Withdrawals Total: " & WithdrawalTotal.ToString()
    Label2.Text = "Deposits Total: " & DepositTotal.ToString()
    Label3.Text = "Selected Cells Total: " & SelectedCellTotal.ToString()
    Label4.Text = "Total entries: " & DataGridView1.RowCount.ToString()
End Sub

備註

屬性 Value 是儲存格所包含的實際資料物件，而 FormattedValue 是這個物件的格式化表示。 ValueType和 FormattedValueType 屬性分別對應至這些值的資料類型。

取得這個屬性的值會呼叫方法， GetFormattedValue 將儲存格值轉換成屬性所 FormattedValueType 表示類型的對等顯示值。這會引發 DataGridView.CellFormatting 事件，您可以處理以自訂值轉換。

如果格式設定失敗，就會 DataGridView.DataError 發生此事件。如果這個事件沒有處理常式，或處理常式會將 DataGridViewDataErrorEventArgs.ThrowException 屬性設定為 true ，則會擲回例外狀況。

適用於

DataGridViewCell.FormattedValue 屬性

定義

屬性值

例外狀況

範例

備註

適用於

另請參閱

意見反應

其他資源