Rowfilter no longer working

Discussion in 'ASP .Net' started by =?Utf-8?B?TWlrZQ==?=, Nov 23, 2004.

  1. I have code that allows the user to filter out car models, such as Chevy
    PickUp, Chevy Truck, etc. by region. When i added code for the Chevy Cars and
    filter by region i'm still getting the Trucks and Pickups in that region. How
    can i only get teh Cars, for the selected region?

    Code:
    with dvCars 'dataview
    .Table = dsCars.tables(0)
    .RowFilter = "(Make =" & selCars & "'" & ") AND (Region=" & "'" &
    selRegion & "'" )"
    end with
     
    =?Utf-8?B?TWlrZQ==?=, Nov 23, 2004
    #1
    1. Advertising

  2. You are missing a single quote before & selCars

    The statement should be:
    ..RowFilter = "(Make =" & "'" & selCars & "'" & ") AND (Region=" & "'" &
    selRegion & "'" )"


    Regards,

    Deepak
    [I Code, therefore I am]




    "Mike" wrote:

    > I have code that allows the user to filter out car models, such as Chevy
    > PickUp, Chevy Truck, etc. by region. When i added code for the Chevy Cars and
    > filter by region i'm still getting the Trucks and Pickups in that region. How
    > can i only get teh Cars, for the selected region?
    >
    > Code:
    > with dvCars 'dataview
    > .Table = dsCars.tables(0)
    > .RowFilter = "(Make =" & selCars & "'" & ") AND (Region=" & "'" &
    > selRegion & "'" )"
    > end with
    >
     
    =?Utf-8?B?RGVlcGFr?=, Nov 24, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Manoj Paramu Das

    RowFilter on Date field

    Manoj Paramu Das, Apr 20, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    3,561
    sachintana
    Apr 21, 2005
  2. Andreas Klemt
    Replies:
    4
    Views:
    19,590
    nabeel
    Apr 19, 2012
  3. Paul Meller

    DataView.Rowfilter String Problem

    Paul Meller, Jan 15, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    711
    Paul Meller
    Jan 15, 2004
  4. Paul Meller

    Rowfilter and OleDB prob

    Paul Meller, Jan 16, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    332
    Paul Meller
    Jan 16, 2004
  5. =?Utf-8?B?VG9t?=

    dataview.rowfilter not working

    =?Utf-8?B?VG9t?=, Aug 24, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    1,103
    =?Utf-8?B?VG9t?=
    Aug 24, 2006
Loading...

Share This Page