vb.net - Retrieve AD results to Listbox VisualStudio -


i trying results active directory listbox created.

normally code in excel vba in case needed move project visual studio can later compile exe.

so here excel vba code working perfectly:

private sub commandbutton1_click()  set objconnection = createobject("adodb.connection") objconnection.open "provider=adsdsoobject;"  set objcommand = createobject("adodb.command") objcommand.activeconnection = objconnection  objcommand.commandtext = _  "<ldap://ou=abc-computers,dc=abc,dc=local>;(objectcategory=computer);name;subtree" set objrecordset = objcommand.execute  rcarray = objrecordset.getrows  userform1.listbox1     .columncount = 1     .clear     .list = application.transpose(rcarray)     .listindex = -1 end  objconnection.close  end sub

i have started new visual studio project (visual basic -> windows form application) , created "form1". when tried incorporate above code didn't work.

below screen:

error http://im54.gulfup.com/yx9eme.png

after trying hours adapt it, couldn't anywhere close :(

any highly appreciated. thanks,

as error message says, first need declare variable before can use it. else wouldn't know scope example.

in order declare variable in vb.net, need use dim keyword:

dim objconnection = createobject("adodb.connection")

some required reading on declaring variables


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more