I have a procedure that is used to look up user permissions in our custom table, There is 1 record for each user and about 20 columns for each of the permissions.
How can i take the column values and place into an array?
All the column are bit type and 1 is int. Is it possible to take the values returned and add to an ArrayList?
And then once the values are in the array, how to loop thru it and go to certain index to check the value.
This is what i have now:
public ArrayList getPermissions(string uid)
{
ArrayList list = new ArrayList();
using (SqlConnection conn = new SqlConnection(this.connDB))
using (SqlCommand cmd = new SqlCommand())
{
try
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "Select_User_Perm";
cmd.CommandType = CommandType.StoredProcedure;
...
Go to the complete details ...