Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012

    Post Unanswered: Hiding particular rows

    Hello everyone,

    I was in middle of developing an library management application but there is an issue. Please do help.

    I want to hide particular rows from datagridview (DataGridView1) where a column which has a checkbox (DataGridViewColumn21) is True.
    I am not able to do it, Please do help with code. How to hide that rows.

    Asaad Bin Shams

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5

    1) Create a view over the table that excludes those rows and only allow access through the view.
    2) Look into Label Based Access Control (LBAC)


  3. #3
    Join Date
    Mar 2012
    I agree with the above poster..... and of the two options I would use the view.

    create view withhiddenrecords as
    select * from datagridview1 where DataGridViewColumn21 is false;

    This will only let them see rows that are not hidden with the true value in column 21.

    Then only grant select the user permissions on the view not the underlying table.

Posting Permissions

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