Bindingsource .Filter using LIKE and numeric fields-VBForums
Results 1 to 5 of 5

Thread: Bindingsource .Filter using LIKE and numeric fields

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Location
    Constanta,Romania
    Posts
    71

    Bindingsource .Filter using LIKE and numeric fields

    Hi !
    I try filtering Bindingsource using LIKE operator for a numeric field,but I can't resolve it.

    id - numeric field
    name - text field
    Code:
        bsrc.Filter = " CStr(ID) LIKE '%"+txtSearch.text+"%' OR name LIKE '%"+txtSearch.text+"%'"
    I got error : "The expression contains undefined function call cstr()"

    Thanks.
    Last edited by ionut_y; Aug 26th, 2007 at 02:27 AM.

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    88,259

    Re: Bindingsource .Filter using LIKE and numeric fields

    So, you tried to use the Filter property and it didn;t work the way you wanted it to? The first thing you should have done was go to the MSDN documentation for that property. Here's a quote from that topic:
    If the underlying data source is a DataSet, DataTable, or DataView, you can specify Boolean expressions using the syntax documented for the DataColumn.Expression property.
    The underlined part is a link, so you would have clicked that link and that would have taken you to that topic, which explains all about the valid syntax.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Location
    Constanta,Romania
    Posts
    71

    Re: Bindingsource .Filter using LIKE and numeric fields

    Quote Originally Posted by jmcilhinney
    So, you tried to use the Filter property and it didn;t work the way you wanted it to? The first thing you should have done was go to the MSDN documentation for that property. Here's a quote from that topic:The underlined part is a link, so you would have clicked that link and that would have taken you to that topic, which explains all about the valid syntax.
    Thanks jmcilhinney !
    I've read your suggestion.It seems I have to create another column,string type and use filter with,but I don't like this because if I have 100 numeric fields and I need to buid a complex filter,do I have to duplicate each ?
    Code:
     Dim cstrID = New DataColumn
            With cstrID 
                .DataType = System.Type.GetType("System.String")
                .ColumnName = "strID"
             End With
            wTbl.Columns.Add(cstrID)
    ......................................
    bsrc.Filter ="strID LIKE .... "
    Thanks !

  4. #4
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    88,259

    Re: Bindingsource .Filter using LIKE and numeric fields

    I can't see why you would be using LIKE on numeric columns anyway? If this is the type of column for which you might want to do that then it should be a text column anyway. An example is a column containing phone numbers. It might contain nothing but numbers but it should be a text filed none the less.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Location
    Constanta,Romania
    Posts
    71

    Re: Bindingsource .Filter using LIKE and numeric fields

    Quote Originally Posted by jmcilhinney
    I can't see why you would be using LIKE on numeric columns anyway? If this is the type of column for which you might want to do that then it should be a text column anyway. An example is a column containing phone numbers. It might contain nothing but numbers but it should be a text filed none the less.
    Thanks jmcilhinney. You're right,I 'll use only one numeric field and one new column,I want to extend search for ID (autoincrement field).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
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.