No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
Hi All 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: [size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] sQuery [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String[/color][/size][size=2] = "Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1" Response.Write(sQuery) [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] myAdapter [/size][size=2][color=#0000ff]As[/color][/size][size=2] OleDbDataAdapter = [/size][size=2][color=#0000ff]New[/color][/size][size=2] … |