Good Day Experts!
Man do I need some direction on this one. I have a Permissions table in a SQL db that I am querying by User. In the table, each permission is a record. So, a User can have several permissions(several records in the table).
Lets say Bob has 3 permissions attached to his Username...so he has 3 records in the table.
Username First Last ..... Permission
BobS Bob Smith Add
BobS Bob Smith Update
BobS Bob Smith Delete
1) Put Username, First, Last in only one line of a DataGridView.
2) Check the corresponding checkbox on the Tab based on each permission( I have
checkboxes for each possible permission on a panel on the Tab).
I can get all 3 records to load in the DataGridView so I know I can return the data from
1) How do I loop through the records and get all the permissions to an array so I can
check the corresponding checkboxes?
2) How do I just load 1 of the records Username, First and Last to the DataGridView?
I appreciate any assistance you all can provide with this task,