Dataset filtering for Authenticated users

Discussion in 'ASP .Net' started by Nugs, Apr 24, 2004.

  1. Nugs

    Nugs Guest

    Hey there guys, This is the first time I am working with forms
    authentication. That said here is a really simple/stupid question:

    Once the user is authenticated how do I filter the datasets for there
    specific records. I have a common field in most of my tables in the DB
    called 'MemberNum' it would be nice to be able to filter the datasets by
    there member numbers.

    I don't even need to know how to do it but rather what to do. Any advice or
    resources on the process/subject would be a great help.

    Nugs
     
    Nugs, Apr 24, 2004
    #1
    1. Advertising

  2. Nugs

    Scott Allen Guest

    Take a look at the DataView class. DataView has a RowFilter property
    which you can use, for example:

    DataView dv = new DataView();
    dv.Table = myDataSet.Tables["Members"];
    dv.RowFilter = "MemberNum = 1 OR MemberNum = 2";


    HTH,

    --
    Scott
    http://www.OdeToCode.com

    On Sat, 24 Apr 2004 14:19:25 -0700, "Nugs" <>
    wrote:

    >Hey there guys, This is the first time I am working with forms
    >authentication. That said here is a really simple/stupid question:
    >
    >Once the user is authenticated how do I filter the datasets for there
    >specific records. I have a common field in most of my tables in the DB
    >called 'MemberNum' it would be nice to be able to filter the datasets by
    >there member numbers.
    >
    >I don't even need to know how to do it but rather what to do. Any advice or
    >resources on the process/subject would be a great help.
    >
    >Nugs
    >
     
    Scott Allen, Apr 25, 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. Jeff 'Jones' Putz

    Sessions of non-authenticated users expire en masse

    Jeff 'Jones' Putz, Nov 14, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    379
    Jeff 'Jones' Putz
    Nov 14, 2003
  2. SamIAm
    Replies:
    1
    Views:
    480
    Ed Gibbs
    Dec 4, 2003
  3. Wayne Carlaw

    Finding Authenticated Users

    Wayne Carlaw, Mar 8, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    424
    Patrick Olurotimi Ige
    Mar 8, 2005
  4. Navin Mishra
    Replies:
    0
    Views:
    328
    Navin Mishra
    Sep 21, 2006
  5. Abhijit
    Replies:
    0
    Views:
    170
    Abhijit
    Apr 12, 2004
Loading...

Share This Page