I have created a dataset and from this I want to retrieve values of a column into a variable. How can I do this?
This is the code:
Dim sQuery As String = "Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1"
Dim myAdapter As OleDbDataAdapter = New OleDbDataAdapter(sQuery, connectionString)
Dim mySet As DataSet = New DataSet
From the above code I need to retrieve all the values of PERMISSION_BUTTON_ID retrieved from the Select statement inot a variable.