Results 1 to 3 of 3

Thread: Datatable.Select filtering

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618

    Datatable.Select filtering

    How do I write a filter for a DataTable so I can get the row I want....here's what I am doing:

    Dim Data() As DataRow
    Dim strFilter As String

    strFilter = "CC_NBR = " & intCC_NBR.ToString & " AND BI_ACCT = 0"

    Data= m_Dataset.Tables("BI_PERSONAL").Select(strFilter)

    And then it excepts
    Last edited by SeanGrebey; Jun 22nd, 2004 at 04:25 PM.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.

  2. #2
    Hyperactive Member CyberHawke's Avatar
    Join Date
    May 2004
    Location
    Washington DC
    Posts
    477
    What is the error you are receiving?

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Mar 2004
    Location
    Orlando, FL
    Posts
    1,618
    The operator is stupid exception....

    I changed it from SQL Statements per record, to loading the whole table and Select Statements, but i forgot to add my keys from my where clause into my select when I changed it, so I was selecting fields that weren't there.
    Sean

    Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.

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