animal415
06-20-2006, 02:00 PM
Using VB.NET, I'm creating an array which holds the data from a 3 column oracle table. I need to loop thru the array to see if "column 3" holds either a "Y" or an "N". If it holds a "Y" then I need the data from that row's
"column 1" to populate a dropdown list. Currently in the table I have 5 rows in the table (but it can grow) and 4 of them are "Y"'s. Only one is an "N" so that one should not be added to the dropdown list.
What I'm trying to do is this: I'm finding each user's ID as they log into the site, and if they are in a certain group, they will see a dropdown with only Column 1's data if Column 3 is "Y". If they belong to an admin group, they'll see a dropdown with all of column 1, regardless of column 3's holdings.
I do not know how to loop thru the array, looking for the content of column 3 and then depending on what that is, using column 1's data to populate or not populate the dropdown list.
Your help would be appreciated.
"column 1" to populate a dropdown list. Currently in the table I have 5 rows in the table (but it can grow) and 4 of them are "Y"'s. Only one is an "N" so that one should not be added to the dropdown list.
What I'm trying to do is this: I'm finding each user's ID as they log into the site, and if they are in a certain group, they will see a dropdown with only Column 1's data if Column 3 is "Y". If they belong to an admin group, they'll see a dropdown with all of column 1, regardless of column 3's holdings.
I do not know how to loop thru the array, looking for the content of column 3 and then depending on what that is, using column 1's data to populate or not populate the dropdown list.
Your help would be appreciated.