Results 1 to 3 of 3

Thread: Possible to use Count(*) filtering a dataView?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2006
    Posts
    90

    Possible to use Count(*) filtering a dataView?

    I have loaded a dataview with data from a datatable. I need to find a way to query the dataview and count the number of records returned from the filter and bind the count value to a label. Is it possible to filter a dataview this way?

  2. #2
    Code Monkey wild_bill's Avatar
    Join Date
    Mar 2005
    Location
    Montana
    Posts
    2,993

    Re: Possible to use Count(*) filtering a dataView?

    VB Code:
    1. Dim dv As New DataView(ds.Tables(0))
    2.         dv.RowFilter = "QualifiedName = '" & trvDatabase.SelectedNode.Text & "'"
    3.         lblConnString.Text = dv.Count.ToString

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jan 2006
    Posts
    90

    Resolved Re: Possible to use Count(*) filtering a dataView?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width