BindingSource.Count Property


Gets the total number of items in the underlying list, taking the current Filter value into consideration.

Namespace:   System.Windows.Forms
Assembly:  System.Windows.Forms (in System.Windows.Forms.dll)

Public Overridable ReadOnly Property Count As Integer

Property Value

Type: System.Int32

The total number of filtered items in the underlying list.

The Count property gets the number of items in the underlying list represented by the List property as modified by the value of the Filter property.

The following code example demonstrates the List, RemoveAt, and Count members. To run this example, paste the code into a form that contains a BindingSource named BindingSource1, two labels named label1 and label2, and a button named button1. Associate the button1_Click method with the Click event for button1. Visual Basic users will need to add a reference to System.Data.dll.

    Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs) _
        Handles button1.Click

        ' Create the connection string, data adapter and data table.
        Dim connectionString As New SqlConnection("Initial Catalog=Northwind;" & _
            "Data Source=localhost;Integrated Security=SSPI;")
        Dim customersTableAdapter As New SqlDataAdapter("Select * from Customers", _
        Dim customerTable As New DataTable()

        ' Fill the the adapter with the contents of the customer table.

        ' Set data source for BindingSource1.
        BindingSource1.DataSource = customerTable

        ' Set the label text to the number of items in the collection before
        ' an item is removed.
        label1.Text = "Starting count: " + BindingSource1.Count.ToString()

        ' Access the List property and remove an item.

        ' Remove an item directly from the BindingSource. 
        ' This is equivalent to the previous line of code.

        ' Show the new count.
        label2.Text = "Count after removal: " + BindingSource1.Count.ToString()

    End Sub
End Class

.NET Framework
Available since 2.0
Return to top